| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding Rows makes entire sheet disappear
I am trying to hide only a few rows in my document. Imagine my suprise when
the entire sheet disappears...I can't do anything at that point except close the program. It doesn't allow me to undo or anything. Anyone have any ideas? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hiding Rows makes entire sheet disappear
press CTRL + G (goto)
go to a cell, for example, A1. Then format-rows-unhide. You might try to go to Format--Rows--unhide even before you use the CTRL+G. -- John C "Des1313" wrote: I am trying to hide only a few rows in my document. Imagine my suprise when the entire sheet disappears...I can't do anything at that point except close the program. It doesn't allow me to undo or anything. Anyone have any ideas? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hiding Rows makes entire sheet disappear
thanks...but that didn't work.
"John C" wrote: press CTRL + G (goto) go to a cell, for example, A1. Then format-rows-unhide. You might try to go to Format--Rows--unhide even before you use the CTRL+G. -- John C "Des1313" wrote: I am trying to hide only a few rows in my document. Imagine my suprise when the entire sheet disappears...I can't do anything at that point except close the program. It doesn't allow me to undo or anything. Anyone have any ideas? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hiding Rows makes entire sheet disappear
What happened when you tried it?
Des1313 wrote: thanks...but that didn't work. "John C" wrote: press CTRL + G (goto) go to a cell, for example, A1. Then format-rows-unhide. You might try to go to Format--Rows--unhide even before you use the CTRL+G. -- John C "Des1313" wrote: I am trying to hide only a few rows in my document. Imagine my suprise when the entire sheet disappears...I can't do anything at that point except close the program. It doesn't allow me to undo or anything. Anyone have any ideas? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inserting Text Makes Numbers Disappear! | Excel Discussion (Misc queries) | |||
| Grouping selection in Pivot table makes all data disappear | Excel Discussion (Misc queries) | |||
| Refreshing pivot makes second data series line disappear from chart !!! | Excel Discussion (Misc queries) | |||
| Conditional hiding of entire rows | Excel Worksheet Functions | |||
| Insert-Subtotals makes Column Outlines disappear | Excel Worksheet Functions | |||
Linear Mode
