Content

• Steps

Hiding unnecessary rows and columns makes your Excel worksheet less clutter-free, especially with large worksheets. Hidden rows will not appear, but affect the formulas in the worksheet. You can easily hide and unhide rows on any version of Excel following the instructions below.

Steps

Method 1 of 2: Select and hide multiple rows

1. 

   Use the selection cursor to highlight the rows that you want to hide. You can hold down the Ctrl key to select multiple rows.

2. 

   
   
   Right click in the highlighted area. Select "Hide". The selected rows are hidden from the worksheet.

3. 

   Unhide rows. To do this, use the selector to highlight the rows above and below the hidden row. For example, you would select rows 4 and row 8 if rows 5-7 are hidden.
   • Right click in the highlighted area.
   • Select "Unhide".
   advertisement

Method 2 of 2: Hide merged rows

1. 

   
   
   Consolidation. With Excel 2013, you can merge / ungroup rows to easily hide and unhide them.
   • Highlight the rows you want to merge and click the "Data" tab.
   • Click the "Group" option in the "Outline" option group.

2. 

   Hide merged rows. You should see a line and a box with a minus sign (-) inside appear next to the merged rows. Click the box to hide the merged rows. Once hidden, the box will display a plus sign (+).

3. 

   
   
   Unhide merged rows. If you want to unhide these rows, just click the box with the plus sign (+). advertisement