How to Unhide Rows in Excel
Jun 19, 2020 ยท 2 minute read
In this page, we are going to explain how to unhide the first row.
-
how to unhide some rows.
-
how to unhide all rows in the excel sheet.
-
how to identify, how many rows and columns are hidden in the sheet.
How to Unhide Rows in Excel.
1- At first, you should select the rows which you want to unhide.
For that, you can select one row above and one row below of the row or rows which you want to unhide them.
2- Right-click on the selected rows.
3- Click on Unhide.
You can also unhide the selected rows by following these steps:
-
Click on the Home tab.
-
Click on the Format.
-
Click on the “Hide and Unhide”.
-
Select “Unhide Rows”.
How to Unhide First Row in Excel.
If your hidden row is the row number one in the spreadsheet.
For selecting it you should follow these steps:
1- Select the row number two which is the row right below it.
2- Select the column heading containing letter A.
3- Right-click on the selected row.
4- Select Unhide.
How to Unhide ALL Rows in Excel.
For unhiding all rows in the excel-sheet, you should select all of the rows in excel.
-
at the top left corner of the sheet Click on the arrow sign.
-
Right-click on one of the selected cells.
-
Click on Unhide.
How to Identify How Many Rows and Column Are Hidden in the Sheet.
1- Click on the File tab.
2- Click on the Info.
3- Click on the"Check for Issues".
4- Click on “Inspect Document”.
5- Click Ok.
6- In the Document Inspector Dialogue go and check “Hidden Rows and Columns”.
7- Click on Inspect.
8- Here you can see How many rows and columns are hidden in this sheet.
