Forum Discussion
HELP! I can't "unhide" my rows
I have a lengthy excel worksheet (200+ rows) that I had hidden some rows, but now I can't "Unhide" them! Any suggestions?
39 Replies
worked for me. thanks
I found a solution on the first day of 2025. Click View --> Unfreeze panes --> Save --> Quite --> Open it again and see
This one worked for me - thank you!
Twobizzy515 - This happens when the Data has a Filter active. Go to Data and unselect Filter.
this was my problem, thanks for the tip!
This works! Thanks
Glad I could help! I can't tell you how many times I've been stuck in this same spot until soneone said,
"Hey, your filter is on." 😁
- The "Unhide" button should perform its function, regardless of sorts or filters on the spreadsheet. Unhide should unhide hidden rows. End of story. If it doesn't, rename it. Right now, I have a spreadsheet where the unhide function does not work but double-clicking the hidden rows does. This makes no sense.
Accidentally discovered that after switching off the sort button (funnel) and then switching it on again, resolved the issue.
Also, copy paste of all cells into another sheet exposed the hidden cells.
Hope this helps.
Ggggg11111
- Cannot unhide rows. HELP.
No Filters.
No Frozen Panes.
No Split screens.
Using Excel on Mac- OK found a solution. Had to unhide columns first, save the file, quit, reopen Excel then unhide. What an abomination. Surely Excel should work in a more smoother way.
for days i cracked my head on try to figure out how to unhide the rows and finally i found this comment and it worked..thank you for the tips..it sure is an abomination...
You should be able to unhide by clicking in the upper left-hand corner of the spreadsheet (which selects all rows and all columns) and then selecting Format....Rows....Unhide
- over 3 years later and you're advice is still helping people! Thank you!
mathetes - it still won't unhide the rows.... 😞
You're clicking on this corner?
What happens when you click there?
Does it all turn gray (or indicate that it's highlighted all rows and columns?
How did you hide the rows in the first place? Did you lock or protect the sheet?
