| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
very odd problem - rows have disappeared. Not hidden, height is no
the first two rows of a workbook are not visible, so it appears to begin with
row 3. rows 1 and 2 can be referenced, but not actually viewed, eg. formula =a1 returns the value in a1, but a1 and the entire row is not visible. I have tried unhiding, does not work. Increasing the height of the invisible row also fails to make it visible. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
very odd problem - rows have disappeared. Not hidden, height is no
Perhaps someone did Windows--Freeze Panes with the worksheet slightly
scrolled down. Check and see if you can go to Windows--Unfreeze Panes. -- John C "PBcorn" wrote: the first two rows of a workbook are not visible, so it appears to begin with row 3. rows 1 and 2 can be referenced, but not actually viewed, eg. formula =a1 returns the value in a1, but a1 and the entire row is not visible. I have tried unhiding, does not work. Increasing the height of the invisible row also fails to make it visible. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
very odd problem - rows have disappeared. Not hidden, height is no
Maybe you have panes frozen.
In xl2003 menus: Window|Unfreeze panes and then scroll up. PBcorn wrote: the first two rows of a workbook are not visible, so it appears to begin with row 3. rows 1 and 2 can be referenced, but not actually viewed, eg. formula =a1 returns the value in a1, but a1 and the entire row is not visible. I have tried unhiding, does not work. Increasing the height of the invisible row also fails to make it visible. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hidden rows columns won't stay hidden | Excel Worksheet Functions | |||
| Formula or Code to keep Hidden Rows Hidden | Excel Worksheet Functions | |||
| hidden/0 height rows | Excel Discussion (Misc queries) | |||
| I need my Hidden Rows to stay hidden when I print the sheet. | Excel Discussion (Misc queries) | |||
| change excel row height without showing hidden rows | Excel Worksheet Functions | |||
Linear Mode
