This wikiHow teaches you how to show hidden rows in an Excel spreadsheet.
Step
Method 1 of 3: Displaying Specific Rows
Step 1. Open the Excel document
Double-click the Excel document that you want to open in Microsoft Excel.
Step 2. Find hidden rows
Check the line numbers to the left of the document as you scroll down. If a number is missing (e.g. line
Step 10. is just below the line
Step 8.), means that the row between the two numbers has been hidden (in the example, it means that row. is hidden
Step 9.). You will also see two lines between the two line numbers.
Step 3. Right-click on the space between the two line numbers
This will bring up a drop-down menu.
-
For example, if the line 9 hidden, means you have to right click the space between the lines
Step 8. da
Step 10..
- On a Mac, you can press and hold the Control key while clicking the space to bring up a drop-down menu.
Step 4. Click Unhide in the drop-down menu
This will bring up the hidden row.
Press Command+S (Mac) or Ctrl+S (Windows) if you want to save your changes
Step 5. Show some hidden rows
If you notice that some rows are missing, you can display all rows by doing the following:
- Press Command (Mac) or Ctrl (Windows) while clicking the row number above the hidden row and the row number below the hidden row.
- Right-click on one of the selected row numbers.
- Click Unhide in the drop-down menu.
Method 2 of 3: Show All Hidden Rows
Step 1. Open the Excel document
Double-click the Excel document that you want to open in Microsoft Excel.
Step 2. Click the "Select All" button
It's a triangle-shaped button in the top-left corner of the spreadsheet, above the number row
Step 1. to the left of the column A. Doing so will select the entire contents of the Excel document.
You can also select an entire document by clicking any cell in the document, then pressing Command+A (Mac) or Ctrl+A (Windows)
Step 3. Click the Home tab
This tab is below the green ribbon at the top of the window.
Skip this step when you are already in the tab Home.
Step 4. Click Format
This menu is in the " Cells " section of the toolbar in the upper right of the window. A drop-down menu will be displayed.
Step 5. Select Hide & Unhide
This option is in the drop-down menu Format. Once you do, a pop-out menu will appear.
Step 6. Click Unhide Rows in the pop-out menu
Doing so will immediately display all rows on the spreadsheet.
Press Command+S (Mac) or Ctrl+S (Windows) if you want to save your changes
Method 3 of 3: Setting Row Height
Step 1. Understand when this method should be done
One way to hide rows is to change the height of the desired row to be so short that it looks like it's disappearing. You can reset the height of all rows to "14.4" (default height in Excel) to work around this.
Step 2. Open the Excel document
Double-click the Excel document that you want to open in Microsoft Excel.
Step 3. Click the "Select All" button
It's a triangle-shaped button in the upper-left corner of the spreadsheet, above the number row
Step 1. to the left of the column A. Doing so will select the entire contents of the Excel document.
You can also select an entire document by clicking any cell in the document, then pressing Command+A (Mac) or Ctrl+A (Windows)
Step 4. Click the Home tab
This tab is below the green ribbon at the top of the window.
Skip this step if you are already in the tab Home.
Step 5. Click Format
It's in the " Cells " section of the toolbar in the top right of the window. A drop-down menu will be displayed.
Step 6. Click Row Height… in the drop-down menu
A pop-up window containing an empty text field will open.
Step 7. Type in the default row height
Type 14.4 into the text field in the pop-up window.
Step 8. Click OK
The changes you make will be applied to all rows in the spreadsheet. All rows that are "hidden" by shortening their height will be shown.
