Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pasting over hidden columns | Excel Discussion (Misc queries) | |||
how do i copy formula down columns avoiding hidden cells | Excel Discussion (Misc queries) | |||
PLEASE HELP - Pasting Cells to WrkSheet with Hidden Columns | Excel Worksheet Functions | |||
How do I lock hidden columns? | Excel Worksheet Functions | |||
How do I prevent hidden columns from being revealed by another use | Excel Discussion (Misc queries) |