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?
you have a filter on. click on the 'data' tab and click Clear under the sort & filter group.
or click on the funnel icon next to Quantity Available and either 'select all' or 'clear filter'
or click on the funnel icon next to Quantity Available and either 'select all' or 'clear filter'
Thank you! This worked for me. I've been going nuts trying to show these rows!
- This worked for me and I stopped pulling my hair out, I was going to distribute the sheet to people that aren't comfortable with Excel...
- knowing we were helpful is thanks enough. Glad it helped and best of luck.
mtarler How can I thank you!? I have been trying to unhide all the rows in my excel file and was about to tell my boss I really messed up, you saved my weekend!!
- KAzim2000 approach worked for me.
For others who may run into this hidden rows problem try View > Freeze Panes > Unfreeze
