how to unhide multiple rows in one go?

[Satnam Randhawa]

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?

 

[Marcelo]

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

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Satnam Randhawa" escreveu:

 

[Satnam Randhawa]

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

 

[arpitsaxena91]

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?

it worked! thanks

 

[puneetchopra24]

Thanks Satnam

It worked

 

[oliviablascari]

Thanks so much! that worked well!

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

 

[mrsblaze1978]

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?

Thanks! Worked perfectly and was super easy!

 

[mymail.mba]

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?

Select the rows you want to unhide and press Ctrl+shift+0
hie and press Ctrl+0.

 

[bijnor.saumya]

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?

Didn't work
Any other way??

 

[joeu2004]

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?

Didn't work[.] Any other way??

It is unclear what "didn't work" for you, since you quote the original
question, not one of the answers.

Suppose rows 101:200 are hidden. In the Name Box, type 100:200 or 101:201
and press Enter to select all of those rows. The point is: include at
least one visible row. Hover the cursor over the selected visible row,
right-click and click on Unhide.

 

[clphilemon]

The selecting all and quickly double clicking worked! Thank you so much! You just saved me unhiding almost 50 individual rows

 

[meyene021]

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?

Double clicking works! Thanks!

 

[malkapetahari]

do restart

 

[nikhilmangal09]

It worked very quickly...Thank you...

 

[aqhacowboy]

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?

I am using Microsoft's Excel 2013 and had the same issue with needing multiple rows to "Unhide", My "easiest solution";
1. select entire worksheet, this is done easily by clicking on the upper left hand down arrow just below the "Name Box".
2. Move into to worksheet, Right click and select "Unhide".

 

[vermabhi.90]

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?

Thanks a lot Satnam, its working well...

 

[pkeating]

Thank you so much, Satnam!
Pat