hidden columns
 

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

hidden columns
 

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.

"Robin Krupp" wrote:

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

hidden columns
 

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