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?
mathetes
Apr 03, 2020Silver Contributor
You should be able to unhide by clicking in the upper left-hand corner of the spreadsheet (which selects all rows and all columns) and then selecting Format....Rows....Unhide
- LampNSJun 30, 2023Copper Contributorover 3 years later and you're advice is still helping people! Thank you!
- Twobizzy515Apr 03, 2020Copper Contributor
mathetes - it still won't unhide the rows.... 😞
- mathetesApr 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.