- 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.
.
Similarly, you may ask, how do you show hidden rows in Excel?
To unhide all rows and columns, select the whole sheet as explained above, and then press Ctrl + Shift + 9 to show hidden rows and Ctrl + Shift + 0 to show hidden columns.
Subsequently, question is, how do I unhide rows in Excel 2016? Excel 2016: Unhide Rows or Columns
- Select the columns or rows that are before and after the one you would like to unhide.
- Select the “Home” tab.
- In the “Cells” area, select “Format” > “Hide & Unhide” > “Unhide Columns” or “Unhide Rows” as desired.
- The column or row should now be unhidden.
Also know, how do you unhide multiple rows in Excel?
Press Ctrl + Shift + 9 to unhide all rows or Ctrl + Shift + 0 (zero) to unhide all columns. If this doesn't work, then right-click on a row or column identifier and select Unhide. Note that you need to select the identifier—you can't just click anywhere and select Unhide using this particular method.
What is the easiest way to unhide and unhide rows in Excel?
Quickly and easily hiding and unhiding rows and columns in Excel
- Select the rows 2 to 6 and press Shift + Alt + right arrow.
- Clicking the small minus sign to the left of row 7 will hide the rows above.
- The icon will change to a plus sign to allow you to quickly unhide the rows.
Why are rows missing in Excel?
How do you auto hide rows in Excel?
- Select the row or column you want to hide. For instance, select row 5 to hide the April data.
- Click the Data tab. In Excel 2003, choose Group and Outline from the Data menu.
- Click Group in the Outline group and Excel will display an outline bracket to the left of row 5.
- To hide row 5, click the minus sign.
