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.

excel sheet

3- Click on Unhide.

unhide cells

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”.

unhide rows excel

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.

unhide first row excel

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.

unhide all rows excel

How to Identify How Many Rows and Column Are Hidden in the Sheet.

1- Click on the File tab.

2- Click on the Info.

Info excel

3- Click on the"Check for Issues".

4- Click on “Inspect Document”.

5- Click Ok.

inspect excel

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.

document inspector excel

excel row