View Single Post
  #18   Report Post  
Posted to microsoft.public.excel.misc
[email protected] sean09211991@gmail.com is offline
external usenet poster
 
Posts: 1
Default how to unhide multiple rows in one go?

For the Excel version I have it behaves a little differently. To unhide all hidden rows: I click the top left corner of the sheet to highlight the whole sheet. This part is same as what you did. Then the next is a little trick. Then I have to put cursor to the far left in the column left of column A and then move cursor to the horizontal line exactly between the two non-hiding rows (if row 2 to row 111 are hidden, then put on the line between row 1 and row 112) and then do a quick double click to unhide all. It will not work, if the cursor is exactly on the dividing line.

On Thursday, December 27, 2007 at 12:06:00 PM UTC-8, Satnam Randhawa wrote:
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

"Marcelo" wrote:

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