hidden columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

some one sent me a sheet in which i cant see columns a and b
i cant un hide them
i cant try to go to a1 and change column width
wooksheet or book isnt protected

but they print and show up in print preview


any ideas whats going on
 
Once when that happened to me (with rows, though) some complication with
"Freeze Panes" prevented me from being able to unhide the rows. Try doing
"Windows . . . Unfreeze Panes" to see if that helps.
 
Hi Robin,

One other possible cause is that worksheet could have its ScrollArea
property set at $C:$IV.
I can't fully test this, my printer's not working so I can't see what
happens with Print Preview. However, I notice that after setting the
worksheet's ScrollArea to $C:$IV that clicking on the little square
just above row 1's row label and to the left of column C's column label
does not select any of the worksheet cells, where it normally selects
the whole sheet.

To check if the sheet's ScrollArea has been altered Right Click the
sheet tab|select "View Code" from the popup|go View|Properties Window
then look for the ScrollArea value and delete the address if you see
one in the right column.

Ken Johnson
 
Back
Top