Why do my rows automatically hide in Excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am working in a workbook where my rows aren't supposed to hide, but for
some reason when I open it, there are important rows hiding. Help!
 
Maybe there are some macros behind the scene do it automatically for you.
Try to disable the macro when you open the file and see what will happen.
 
Same thing happens to me in a worbook with no macros I have ever written. It only happens to me when I am dealing with large worksheet, like 10000+ rows. At the same time some rows get enlarged to almost the size of my entire viewable area. Very frustrating. First thing I do when I open large workbooks like this is click the first row, scroll down to the last and shift select then unhide. then switch to max zoom out and auto adjust row height for those that are monstrous. If I didn't have to do this, I would be slightly happier on the whole.
 
Go to view / Freeze Panes / Unfreeze Panes.
Then scroll up with your mouse or up/down arrow key to the row(s) that initially appeared to be automatically hidden.
This should make the rows appear again.
You can re-freeze your panes again later.
 
Back
Top