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?
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?
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?
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.
