ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Hiding Rows makes entire sheet disappear (https://www.excelbanter.com/excel-discussion-misc-queries/197067-hiding-rows-makes-entire-sheet-disappear.html)

Des1313

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?

John C[_2_]

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?


Des1313

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?


Dave Peterson

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


All times are GMT +1. The time now is 12:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com