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.

This page provides step-by-step guides on how to hide rows in Excel and how to unhide rows in Excel.

How to Hide Rows in Excel

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

  1. Selecting Rows in a Worksheet
    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").

  2. 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
Hide Rows Through Format Option on Ribbon

How to Unhide Rows in Excel

  1. Select the rows that you want to unhide. You can do this by either:

    • Selecting Hidden Rows by Dragging Down Row Labels
      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

    • Top Left Corner of Worksheet
      Clicking on the top left corner
      selects the entire worksheet

      Selecting the top left corner of the worksheet, to select the entire worksheet.

  2. 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
Unhide Rows Through Format Option on Ribbon