Why do my rows automatically hide in Excel?

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!
 
D

Daniel CHEN

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.
 

Saw

Joined
Jan 22, 2014
Messages
1
Reaction score
0
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.
 
Joined
Jul 31, 2016
Messages
1
Reaction score
0
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top