View Single Post
  #2   Report Post  
Anon y mous
 
Posts: n/a
Default

Unhiding requires that you highlight the rows on either side of the hidden
rows.
If you are trying to unhide the first row, it can be tricky, you might have
to select the whole spreasheet by clicking on the blank box where the rows
and columns intersect (this selects the whole spreadsheet. Next after
unhiding all rows, try to reset your row height to a default value to see if
that brings them back.

Provided you have not protected the worksheet or book, If these fail, you
might have a corrupt spreadsheet.

Are you using form design or vb tools on this spreadsheet? sometimes
leaving design mode on and protect 'on' can prevent you from unprotecting
and doing some normal things..

Good luck


"haibebu2" wrote in message
...
I did hide some of the rows in my excel file. But then I could not unhide
them ? What is the reason for this behavior ?