how to unhide multiple rows in one go?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Satnam Randhawa - 26 Dec 2007 12:54 GMT

I have a worksheet with close to 100 rows out which 15-20 are hidden. How do
I unhide all the rows in one work sheet in one go without having to drag them
out individually?

Reply to this Message

Marcelo - 26 Dec 2007 13:00 GMT

select all rows (100) right click (on row number) adn unhide

hth

Signature

regards from Brazil
Thanks in advance for your feedback.
Marcelo

> I have a worksheet with close to 100 rows out which 15-20 are hidden. How do
> I unhide all the rows in one work sheet in one go without having to drag them
> out individually?

Reply to this Message

Satnam Randhawa - 27 Dec 2007 20:06 GMT

i had tried that but doesnt work
I feel i wasnt able to do it coz the row was not just hidden..but its height
was reset to Zero or something..
Anywas here is how i got to get it to work:
select the entire sheet(Ctrl+ A OR by clicking on that little box in the
upper left hand corner where column headings A,B,C..and row numbers
1,2,3..meet ) and point the mouse to one of the rows which is above or below
the row thats hidden and then quickly do a double click with left mouse
button..this will unhide all the rows in worksheet.

Psst..i cant take credit for this one..read it one of the logs here only..

:-)

But thanks for trying..
Satnam
India

> select all rows (100) right click (on row number) adn unhide
>
[quoted text clipped - 3 lines]
> > I unhide all the rows in one work sheet in one go without having to drag them
> > out individually?

Reply to this Message