How to Hide and Unhide Rows in Excel

Sometimes you might want to hide some of the rows in your Excel worksheet.

Note that, if you want to hide rows satisfying certain criteria, you might prefer to use the Excel Autofilter.

How to Hide Rows in Excel

If you want to hide one or more rows in Excel:

To select rows 2 & 3, click on row label "2" and drag down to row "3"

Select the row(s) to be hidden.

(Note, you can select one or more rows by selecting the row label(s) to the left of your worksheet - E.g. to select rows 2 and 3, click on the row label "2" and drag down to row "3").
Hide the selected rows by either:
- Using the mouse to right-click on the selected row(s) and then selecting Hide from the right-click menu.
or
- Selecting the option Format from the 'Cells' group of the Home tab on the Excel ribbon and, from within the 'Format' drop-down menu, selecting Hide & Unhide->Hide Rows.

Hide Rows Through Format Option on Ribbon

Select the rows that you want to unhide. You can do this by either:
- To select rows 1-4 (including hidden rows 2 & 3, click on row label "1" and drag down to row "2"
  
  Dragging down the row labels above and below the hidden row(s) - (E.g. If rows 2 and 3 are hidden, click on the row label "1" and drag down to row "4" to select rows 1-4).
or
- Clicking on the top left corner
  selects the entire worksheet
  
  Selecting the top left corner of the worksheet, to select the entire worksheet.
Unhide the selected rows by either:
- Using the mouse to right-click on the selected row(s) and then selecting Unhide from the right-click menu.
or
- Selecting the option Format from the 'Cells' group of the Home tab on the Excel ribbon and, from within the 'Format' drop-down menu, selecting Hide & Unhide->Unhide Rows.

Unhide Rows Through Format Option on Ribbon