rows won't unhide

  • Thread starter Thread starter unclebuckle
  • Start date Start date
U

unclebuckle

I have this worksheet that I have hidden rows, sorted, and saved. Now after
a few sorts and saves, I am unable to unhide the rows that I originally hid.

Here's what I've tried so far:

Selected the rows adjacent to the hidden rows and tried the unhide command
(right click, unhide) and (format menu, unhide).
Selected the entire worksheet and tried the unhide command. (right click,
unhide) and (format menu, unhide).
Selected the rows surrounding the hidden rows and tried the unhide command
(right click, unhide) and (format menu, unhide).

Does anyone have another idea? I have tried this using both excel 2003 and
2007.
 
Maybe this:

Select the entire sheet
Goto Format>Row>Height

Type in a number. The default is 12.75

Ok
 
Thanks, Biff

Yep, tried that. It didn't work.

In fact I can see the rows that are hidden actually have a height of 0 and
when I try to stretch them out, they pop back to zero when I release the
mouse button.
 
Is the data filtered?

Data|Filter|show all
(in xl2003)

But I could unhide rows by selecting rows surrounding the hidden rows and
autofitting.

Any chance you have an event macro that's hiding stuff for you--based on
selection change?
 
Back
Top