Download Article
Download Article
Unhiding a Specific Row
Find the hidden row. Look at the row numbers on the left side of the document as you scroll down; if you see a skip in numbers (e.g., row 23 is directly above row 25), the row in between the numbers is hidden (in 23 and 25 example, row 24 would be hidden). You should also see a double line between the two row numbers.
It’s in the drop-down menu. Doing so will prompt the hidden row to appear.
Unhide a range of rows. If you notice that several rows are missing, you can unhide all of the rows by doing the following:
This tab is just below the green ribbon at the top of the Excel window.
If you’re already on the Home tab, skip this step.
This option is in the “Cells” section of the toolbar near the top-right of the Excel window. A drop-down menu will appear.
You’ll find this option in the Format drop-down menu. Selecting it prompts a pop-out menu to appear.
Adjusting Row Height
This tab is just below the green ribbon at the top of the Excel window.
If you’re already on the Home tab, skip this step.
This option is in the “Cells” section of the toolbar near the top-right of the Excel window. A drop-down menu will appear.
It’s in the drop-down menu. This will open a pop-up window with a blank text field in it.
Enter the default row height. Type 14.4 into the pop-up window’s text field.
Community Q&A
Add New Question
The top 7 rows of my Excel worksheet have disappeared. I’ve tried to “unhide” from the Format menu, but nothing happens. What do I do?
You’ll have to unlock the cells (via the format pop-up), then hide them all before unhiding them.
There is a possibility you did not hide the rows but reduced your rows’ height to minimum. Select all rows above and below of your 7 rows and increase rows height from format menu. It will re-adjust the height of rows and your rows will be visible.
This article was written by Jack Lloyd. Jack Lloyd is a Technology Writer and Editor for wikiHow. He has over two years of experience writing and editing technology-related articles. He is technology enthusiast and an English teacher. This article has been viewed 309,392 times.
How helpful is this?
Updated: November 17, 2020
Thanks to all authors for creating a page that has been read 309,392 times.
Robert Theriault
“I had some rows hidden and couldn’t figure out how to unhide the rows. The article solved that problem for me. Thanks” …” more