how to unhide multiple rows in one go?

  • Thread starter Thread starter Satnam Randhawa
  • Start date Start date
S

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?
 
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:
 
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
 
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?
Click to expand...

it worked! thanks :D
 
Thanks so much! that worked well! :D

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
Click to expand...
 
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?
Click to expand...

Thanks! Worked perfectly and was super easy!
 
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?
Click to expand...

Select the rows you want to unhide and press Ctrl+shift+0
hie and press Ctrl+0.
 
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?
Click to expand...

Didn't work
Any other way??
 
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?
Click to expand...

Didn't work[.] Any other way??
Click to expand...

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.
 
The selecting all and quickly double clicking worked! Thank you so much! You just saved me unhiding almost 50 individual rows :)
 
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?
Click to expand...

Double clicking works! Thanks! :)
 
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?
Click to expand...

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".
 
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?
Click to expand...

Thanks a lot Satnam, its working well...
 
Back
Top