Cannot unhide top rows
I have tried to unhide rows 1 - 53 which have been hidden from view. I have tried to select all and unhide, I have tried to select all and unhide via the top menu. I have checked to see if cells are locked or hidden, and they are not.
I am sort of at a loss on how to unhide these top rows of data. Suggestions?
Last edited by physicsgal; 05-04-2011 at 03:32 PM. Reason: Solved
One thing you might check is the row height of all your rows. If rows 1-53 somehow got really small, they appear hidden, but they're not. Select all your rows and set the row height at 15, unless this is going to mess up your formatting. Hope this helps.
physicsgal,
Could be a filter issue instead of the rows actually being hidden.
To check filter, go to Data -> Clear
Hope that helps,
~tigeravatar
I tried both suggestions and no result.... any other thoughts?
Appreciate the help!
I don't mean to sound basic, but when you are selecting all the rows, are you doing a CTRL A, or are you highlighting starting with 54. Make sure you are doing a CTRL A. Sorry if I'm stating the obvious.
It's ok, and just to triple check, i made sure i was doing a CTRL+A and tried it all again. No luck
Is Freeze pane active?
Any macro running?
The panes were frozen.... I didn't even think of that! Thank you all for your help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks