Forum Discussion
HELP! I can't "unhide" my rows
My next guess is that they aren't hidden but just made to a very small height.
if you highlight the whole sheet (as done above) you can double click the line between any 2 rows to auto adjust the row heights.
- 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'Thank you! This worked for me. I've been going nuts trying to show these rows!
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!!
- knowing we were helpful is thanks enough. Glad it helped and best of luck.
For others who may run into this hidden rows problem try View > Freeze Panes > Unfreeze
I see the problem--and your wits are hereby relieved.
You've been filtering out a lot of rows under the header "Quantity Available"-- just go to that little funnel in the header and allow it to select ALL rows.
OR turn off the filter altogether.
- I have been fighting with an a spreadsheet created by someone else and this reply solved all my problems! thank you so much
Had the same problem but the interesting thing is that I did not intentionally filter the data; this happened all by itself. Microsoft should update their HELP suggestion to include clearing filters.
- Thank you.
