rows won't unhide


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.
 
Ad

Advertisements

T

T. Valko

Maybe this:

Select the entire sheet
Goto Format>Row>Height

Type in a number. The default is 12.75

Ok
 
U

unclebuckle

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.
 
D

Dave Peterson

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?
 
Ad

Advertisements

U

unclebuckle

Thanks Dave I had a filter on and didn't realize.

Whew, another crisis resolved.

UB
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top