How to Unhide All Rows in Excel

Tue-May-2023
1

Here are the steps on how to unhide all rows in Excel:

  1. Select the entire worksheet by pressing Ctrl+A.
  2. Press Ctrl+Shift+9.

This will unhide all rows in the worksheet.

You can also unhide all rows by following these steps:

  1. Click on the “Home” tab.
  2. In the “Cells” group, click on the “Format” button.
  3. In the “Format Cells” dialog box, click on the “Visibility” tab.
  4. Under “Hidden rows”, select the “Unhide all rows” checkbox.
  5. Click on the “OK” button.

This will also unhide all rows in the worksheet.