- Categories
- Computers and Electronics
- Software
- Office
- Spreadsheets
- Microsoft Excel
Download Article
Find missing excel rows and resize them for better visibility
Written byJack Lloyd
Last Updated: March 21, 2024Fact Checked
Download Article
- Unhiding a Single Row |
- Unhiding All Rows |
- Resizing a Row in Excel |
- Video |
- |
- Tips
ARTICLE
VIDEO
Are there hidden rows in your Excel worksheet that you want to bring back into view? Unhiding rows is easy, and you can even unhide multiple rows at once. This wikiHow article will teach you one or more rows in Microsoft Excel on your PC or Mac.
Method 1
Method 1 of 3:
Unhiding a Specific Row
Download Article
1
Open the Excel document. Double-click the Excel document that you want to use to open it in Excel.
2
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.[1]
Advertisem*nt
3
Right-click the space between the two row numbers. Doing so prompts a drop-down menu to appear.
- For example, if row 24 is hidden, you would right-click the space between 23 and 25.
- On a Mac, you can hold down Control while clicking this space to prompt the drop-down menu.
4
Click Unhide. It's in the drop-down menu. Doing so will prompt the hidden row to appear.[2]
- You can save your changes by pressing Ctrl+S (Windows) or ⌘ Command+S (Mac).
5
Unhide a range of rows. If you notice that several rows are missing, you can unhide all of the rows by doing the following:[3]
- Hold down Ctrl (Windows) or ⌘ Command (Mac) while clicking the row number above the hidden rows and the row number below the hidden rows.
- Right-click one of the selected row numbers.
- Click Unhide in the drop-down menu.
Advertisem*nt
Method 2
Method 2 of 3:
Unhiding All Hidden Rows
Download Article
1
See Also6 Amazing Excel tools to improve your spreadsheets and data analysisHow to Unhide Columns in Excel: 4 Easy Step-by-Step MethodsHow to Unhide All Hidden Rows & Columns in Excel (At Once)9 Ways to Unhide Columns in Microsoft ExcelOpen the Excel document. Double-click the Excel document that you want to use to open it in Excel.
2
Click the "Select All" button. This triangular button is in the upper-left corner of the spreadsheet, just above the 1 row and just left of the A column heading. Doing so selects your entire Excel document.
- You can also click any cell in the document and then press Ctrl+A (Windows) or ⌘ Command+A (Mac) to select the whole document.
3
Click the Home tab. 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.
4
Click Format. This option is in the "Cells" section of the toolbar near the top-right of the Excel window. A drop-down menu will appear.[4]
5
Select Hide & Unhide. You'll find this option in the Format drop-down menu. Selecting it prompts a pop-out menu to appear.[5]
6
Click Unhide Rows. It's in the pop-out menu. Doing so immediately causes any hidden rows to appear in the spreadsheet.
- You can save your changes by pressing Ctrl+S (Windows) or ⌘ Command+S (Mac).
Advertisem*nt
Method 3
Method 3 of 3:
Adjusting Row Height
Download Article
1
Understand when this method is necessary. One form of hiding rows involves the height of the row(s) in question to be so short that the row effectively disappears. You can reset the height of all spreadsheet rows to "14.4" (the default height) to address this.
2
Open the Excel document. Double-click the Excel document that you want to use to open it in Excel.
3
Click the "Select All" button. This triangular button is in the upper-left corner of the spreadsheet, just above the 1 row and just left of the A column heading. Doing so selects your entire Excel document.
- You can also click any cell in the document and then press Ctrl+A (Windows) or ⌘ Command+A (Mac) to select the whole document.
4
Click the Home tab. This tab is just below the green ribbon at the top of the Excel window.[6]
- If you're already on the Home tab, skip this step.
5
Click Format. This option is in the "Cells" section of the toolbar near the top-right of the Excel window. A drop-down menu will appear.[7]
6
Click Row Height…. It's in the drop-down menu. This will open a pop-up window with a blank text field in it.
7
Enter the default row height. Type 14.4 into the pop-up window's text field.
8
Click OK. Doing so will apply your changes to all rows in the spreadsheet, thus unhiding any rows which were "hidden" via their height properties.[8]
- You can save your changes by pressing Ctrl+S (Windows) or ⌘ Command+S (Mac).
Advertisem*nt
Community Q&A
Search
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?
Community Answer
You'll have to unlock the cells (via the format pop-up), then hide them all before unhiding them.
Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission.Support wikiHowYesNo
Not Helpful 16Helpful 51
Question
I have the same problem - top 7 rows aren't displaying. I tried to unlock but they weren't locked and the spreadsheet isn't protected. I can see the top 7 rows only in print preview.
Anuj_Kumar1
Community Answer
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.
Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission.Support wikiHowYesNo
Not Helpful 19Helpful 6
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Advertisem*nt
Tips
If you don't see Unhide Columns or Unhide Rows pop up, make sure you're right-clicking inside the column or row label.
Thanks
Helpful0Not Helpful0
Tips from our Readers ![How to Unhide Rows in Excel: Showing All Rows in a Worksheet (27) How to Unhide Rows in Excel: Showing All Rows in a Worksheet (27)](data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==)
The advice in this section is based on the lived experiences of wikiHow readers like you. If you have a helpful tip you’d like to share on wikiHow, please submit it in the field below.
- If a column is filtered to hide rows, you have to remove that filter first. Otherwise you won't be able to unhide the rows in that column.
Submit a Tip
All tip submissions are carefully reviewed before being published
Submit
Thanks for submitting a tip for review!
Advertisem*nt
Video
Read Video Transcript
You Might Also Like
Advertisem*nt
References
- ↑ https://support.office.com/en-us/article/hide-or-show-rows-or-columns-659c2cad-802e-44ee-a614-dde8443579f8
- ↑ https://support.microsoft.com/en-au/office/hide-or-show-rows-or-columns-659c2cad-802e-44ee-a614-dde8443579f8
- ↑ https://support.microsoft.com/en-au/office/hide-or-show-rows-or-columns-659c2cad-802e-44ee-a614-dde8443579f8
- ↑ https://support.microsoft.com/en-au/office/unhide-the-first-column-or-row-in-a-worksheet-d6b47608-80ee-4021-9b51-6a1f57269ec9
- ↑ https://support.microsoft.com/en-au/office/unhide-the-first-column-or-row-in-a-worksheet-d6b47608-80ee-4021-9b51-6a1f57269ec9
- ↑ https://support.microsoft.com/en-gb/office/change-the-column-width-and-row-height-72f5e3cc-994d-43e8-ae58-9774a0905f46
- ↑ https://support.microsoft.com/en-gb/office/change-the-column-width-and-row-height-72f5e3cc-994d-43e8-ae58-9774a0905f46
- ↑ https://support.microsoft.com/en-gb/office/change-the-column-width-and-row-height-72f5e3cc-994d-43e8-ae58-9774a0905f46
About This Article
![How to Unhide Rows in Excel: Showing All Rows in a Worksheet (43) How to Unhide Rows in Excel: Showing All Rows in a Worksheet (43)](https://i0.wp.com/www.wikihow.com/images/thumb/4/4e/ExpertAvatar2.png/-crop-100-100-100px-ExpertAvatar2.png)
Written by:
Jack Lloyd
wikiHow Technology Writer
This article was co-authored by wikiHow staff writer, 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 703,785 times.
How helpful is this?
Co-authors: 9
Updated: March 21, 2024
Views:703,785
Categories: Microsoft Excel
Article SummaryX
1. Open your spreadsheet in Microsoft Excel.
2. Select all data in the worksheet. A quick way to do this is to click the ""Select all"" button at the top-left corner of the worksheet.
3. Click the ""Home"" tab.
4. Click the ""Format"" button in the ""Cells"" section of the toolbar. A menu will expand.
5. Select ""Hide & Unhide"" on the menu.
6. Click ""Unhide rows"" to make all hidden rows visible.
Did this summary help you?
In other languages
Spanish
Portuguese
German
Russian
French
Indonesian
Arabic
Thai
Chinese
Dutch
Hindi
Turkish
Korean
- Send fan mail to authors
Thanks to all authors for creating a page that has been read 703,785 times.
Is this article up to date?
Advertisem*nt