Buzz
This article provides step-by-step instructions for un-hiding one or more rows in a Microsoft Excel spreadsheet.
Steps
Unhide a Row
Open the Excel file. Double-click on the Excel document you want to open.
Find the Hidden Row. You will notice the row numbers displayed to the left of the text as you scroll down; if a number is missing (for example, after row 23 comes row 25), the row between these two numbers is hidden (in this example, row 24 is hidden). You will also see a double line between these rows.
Right-click on the space between the two rows. This will open a menu.
- For example, if row 24 is hidden, right-click on the space between row 23 and row 25.
- On a Mac, you can press the Control key while right-clicking to open the menu.
Click Unhide (Unhide). This option appears in the menu. Selecting it will make the hidden row visible again.
- You can save your changes by pressing Ctrl+S (on Windows) or ⌘ Command+S (on Mac).
Unhide Multiple Consecutive Rows. If you notice several rows are hidden, unhide all of them with the following steps:
- Press Ctrl (on Windows) or ⌘ Command (on Mac) while clicking on the row numbers above and below the hidden rows.
- Right-click on one of the selected rows.
- Click on Unhide in the menu that appears.
Unhide All Hidden Rows
Open an Excel document. Double-click on the Excel file you want to open.
Click the "Select All" button. This rectangular button appears at the top-left corner of the spreadsheet, just above row number 1 and to the left of column header A. This action will select the entire Excel worksheet.
- You can also click any cell in the document and press Ctrl+A (on Windows) or ⌘ Command+A (on Mac) to select the entire worksheet.
Click the Home. This tab is located just below the green section at the top of the Excel window.
- If you've already opened the Home tab, you can skip this step.
Click on the Format (Formatting). This option is located in the "Cells" section of the toolbar near the top-right corner of the Excel window. A list of formatting choices will appear here.
Select Hide & Unhide (Hide and Unhide). This option is found in the Format menu. A secondary menu will appear once you click it.
Click on Unhide Rows (Unhide rows). This option is found in the menu. It will immediately make any hidden rows visible in the worksheet.
- You can save the changes by pressing Ctrl+S (on Windows) or ⌘ Command+S (on Mac).
Adjust row height
Know when to apply this method. A common reason for rows being hidden is that their height is too small to be visible in the worksheet. To fix this, you can reset the row height for the entire sheet to "14.4" (the default row height).
Open an Excel document. Double-click on the Excel file you want to open.
Click the "Select All" button. This rectangular button appears at the top-left corner of the spreadsheet, just above row number 1 and to the left of the column header A. This action will select the entire Excel worksheet.
- You can also click any cell in the document and press Ctrl+A (on Windows) or ⌘ Command+A (on Mac) to select the entire worksheet.
Click on the Home. This tab is located below the green section at the top of the Excel window.
- If you have already opened the Home tab, feel free to skip this step.
Click on the Format option. This is located under the "Cells" section of the toolbar, near the top-right corner of the Excel window. A dropdown menu will appear here.
Click on the Row Height… option. This selection can be found in the menu currently displayed. A new window will pop up with an empty text input field.
Enter the default row height. Type 14.4 into the input field that appears in the new window.
Click on the OK. This will apply the changes to all rows in the spreadsheet, revealing any rows that were previously "hidden" due to adjusted row heights.
- You can save the changes by pressing Ctrl+S (on Windows) or ⌘ Command+S (on Mac).
