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 03, 2020Copper Contributor
mathetes - it still won't unhide the rows.... 😞
mathetes
Apr 03, 2020Silver Contributor
You're clicking on this corner?
What happens when you click there?
Does it all turn gray (or indicate that it's highlighted all rows and columns?
How did you hide the rows in the first place? Did you lock or protect the sheet?
- Twobizzy515Apr 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.
- mtarlerApr 06, 2020Silver Contributorare 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.- Twobizzy515Apr 06, 2020Copper Contributor