Forum Discussion
HELP! I can't "unhide" my rows
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.
Never mind. There were filters (in a hidden row). Spend almost an hour looking for something out of the ordinary, until I noticed that the very top row was also hidden... containing filters of course.
- Same problem, no luck with the previous info.
Hidden rows. I can not get them to unhide using:
- clicking top left corner (selecting entire worksheet), then unhiding all rows using format > hide/unhide
- selecting the rows above and below, and right-clicking > unhide
- panes are not freezed
- there is no filter used in the worksheet, so it's not that.
What works:
- double clicking on the thick horizontal lines where the hidden rows are located => this shows the hidden rows using the default height (15) whereas they were 32 high before I hid them.
Any ideas? mathetes You are a Wizard! That solved my issue, as well! Cheers!
Thank you for suggesting looking at filtering. was going to go insane with this one. all ok now!
