How to Hide Rows in Excel

Hiding rows and columns you don't need can make your Excel spreadsheet much easier to read, especially if it's large. Hidden rows don't clutter up your sheet, but still affect formulas. You can easily Hide and Unhide rows in any version of...
Method 1 of 2:

Hiding a Selection of Rows

  1. How to Hide Rows in Excel Picture 1How to Hide Rows in Excel Picture 1
    Use the row selector to highlight the rows you wish to hide. You can hold the Ctrl key to select multiple rows.
  2. How to Hide Rows in Excel Picture 2How to Hide Rows in Excel Picture 2
    Right-click within the highlighted area. Select 'Hide'. The rows will be hidden from the spreadsheet.
  3. How to Hide Rows in Excel Picture 3How to Hide Rows in Excel Picture 3
    Unhide the rows. To unhide the rows, use the row selector to highlight the rows above and below the hidden rows. For example, select Row 4 and Row 8 if Rows 5-7 are hidden.
    1. Right-click within the highlighted area.
    2. Select 'Unhide'.
Method 2 of 2:

Hiding Grouped Rows

  1. How to Hide Rows in Excel Picture 4How to Hide Rows in Excel Picture 4
    Create a group of rows. With Excel 2013, you can group/ungroup rows so that you can easily hide and unhide them.
    1. Highlight the rows you want to group together and click "Data" tab.
    2. Click "Group" button in the "Outline" Group.
  2. How to Hide Rows in Excel Picture 5How to Hide Rows in Excel Picture 5
    Hide the group. A line and a box with a (-) minus sign appears next to those rows. Click the box to hide the "grouped" rows. Once the rows are hidden the small box will display a (+) plus sign.
  3. How to Hide Rows in Excel Picture 6How to Hide Rows in Excel Picture 6
    Unhide the rows. Click (+) box if you want to unhide the rows.
4 ★ | 1 Vote