Forum Discussion
Twobizzy515
Apr 03, 2020Copper Contributor
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?
Twobizzy515
Apr 06, 2020Copper Contributor
mathetes - Yes, clicking in that corner, highlights the entire page. Clicking on Format, and Unhide, and nothing happens. I do not believe I locked the page.
mtarler
Apr 06, 2020Silver Contributor
are you sure there are rows hidden? Do the numbers "skip"?
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.
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.
- Twobizzy515Apr 06, 2020Copper Contributor
- mtarlerApr 06, 2020Silver Contributoryou 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'- dawncFeb 20, 2025Copper Contributor
Thank you! This worked for me. I've been going nuts trying to show these rows!
- mathetesApr 06, 2020Silver Contributor
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.
- construction1220Jan 09, 2024Copper ContributorI have been fighting with an a spreadsheet created by someone else and this reply solved all my problems! thank you so much