This article shows how to display one or more rows of an Excel sheet that have been previously hidden.
Steps
Method 1 of 3: Uncover a Specific Row
Step 1. Open the Excel document to be processed
Double-click the icon of the Excel file you want to open.
Step 2. Locate the hidden row
Review the row numbers on the left side of the worksheet by scrolling down. If you notice that some numbers are missing (for example the line after the number
Step 23. is the num
Step 25.), it means that the row identified by the missing number is hidden (in the example the row between the number
Step 23. and the number
Step 25., that is l
Step 24., is hidden). Furthermore, the cells of the two lines in question should be separated by a double horizontal line.
Step 3. Select the space that separates the numbers of the two lines under examination with the right mouse button
A context menu will be displayed.
-
For example, if the hidden line is the number
Step 24., you will need to select the space that separates the rig numbers
Step 23
Step 25. with the right mouse button.
- If you are using a Mac, to simulate pressing the right mouse button, you will have to hold down the Control key on the keyboard while clicking on the indicated point.
Step 4. Click Discover
It is one of the options present in the drop-down menu that appeared. In this way the hidden line will become visible again.
Now save the new changes by pressing the key combination Ctrl + S (on Windows) or ⌘ Command + S (on Mac)
Step 5. Discover a set of hidden lines
If you notice the lack of a set of multiple lines, you can find them all together by following these instructions:
- Hold down the Ctrl (on Windows) or ⌘ Command (on Mac) key while clicking on the line number that precedes and follows the group of hidden lines;
- Select one of the numbers of the highlighted lines with the right mouse button;
- Click on the option You discover present in the context menu that appeared.
Method 2 of 3: Uncover All Hidden Lines
Step 1. Open the Excel document to be processed
Double-click the icon of the Excel file you want to open.
Step 2. Click on the "Select All" button
It has a triangular shape and is placed in the upper left corner of the Excel sheet, exactly above the number row
Step 1. and to the left of the column header TO. In this way all the cells present in the sheet in question will be automatically selected.
Alternatively, you can click on any cell in the sheet and then press the key combination Ctrl + A (on Windows) or ⌘ Command + A (on Mac), to get the same result
Step 3. Click on Home
It is one of the tabs that make up the Excel ribbon located at the top of the program window.
Skip this step if the card Home is already selected.
Step 4. Click Format
It is one of the buttons in the "Cells" group of the "Home" tab. It is located at the top right of the Excel window. A drop-down menu will appear.
Step 5. Select the Hide and unhide item
It is one of the options listed within the drop-down menu Format. A small submenu will appear next to the first one.
Step 6. Click Unhide Lines
It is one of the items in the menu that appeared. All hidden rows of the Excel sheet under examination will be automatically made visible.
Now save the new changes by pressing the key combination Ctrl + S (on Windows) or ⌘ Command + S (on Mac)
Method 3 of 3: Change the Height of a Row
Step 1. Find out when it is useful to use this procedure
One of the ways in which you can hide the rows of an Excel sheet is to set the height of the cells that compose them to zero, so that they actually disappear from view. You can restore the default height of all rows in an Excel sheet (equal to 15 pixels) by following the instructions in this section of the article.
Step 2. Open the Excel document to be processed
Double-click the icon of the Excel file you want to open.
Step 3. Click on the "Select All" button
It has a triangular shape and is placed in the upper left corner of the Excel sheet, exactly above the number row
Step 1., to the left of the column header TO. In this way all the cells present in the sheet in question will be automatically selected.
Alternatively, you can click on any cell on the sheet and then press the key combination Ctrl + A (on Windows) or ⌘ Command + A (on Mac) to get the same result
Step 4. Click on Home
It is one of the tabs that make up the Excel ribbon located at the top of the program window.
If the card Home is already selected, skip this step.
Step 5. Click the Format button
It is contained in the "Cells" group of the "Home" tab. It is located at the top right of the Excel window. A drop-down menu will appear.
Step 6. Click on Row height…
It is one of the items listed in the drop-down menu that appeared. A pop-up window will appear in which there will be an empty text field.
Step 7. Enter the default value which corresponds to the standard row height of an Excel sheet
Enter the number 15 in the text field of the pop-up window.
Step 8. Click OK
The changes will apply to all rows on the worksheet, so any rows that are currently hidden because their height has been set to "0" will become visible again.
