Buzz
Hiding unnecessary rows and columns can make your Excel sheet appear cleaner, particularly when working with large datasets. Hidden rows will not be visible but will still affect the formulas in the sheet. You can easily hide and unhide rows in any version of Excel by following the instructions below.
Steps
Select and Hide Multiple Rows
Use the cursor to highlight the rows you want to hide. You can hold the Ctrl key to select multiple rows.
Right-click on the highlighted area. Select “Hide.” The selected rows will disappear from the sheet.
Unhide rows. To do this, use the cursor to highlight the rows above and below the hidden rows. For example, select row 4 and row 8 if rows 5-7 are hidden.
- Right-click on the highlighted area.
- Select “Unhide.”
Hide Grouped Rows
Group rows. In Excel 2013, you can group/ungroup rows to easily hide and unhide them.
- Highlight the rows you want to group and click on the "Data" tab.
- Click the "Group" option in the "Outline" section.
Hide grouped rows. You will see a line and a box with a minus sign (-) appear next to the grouped rows. Click the box to hide the grouped rows. After hiding, the box will display a plus sign (+).
Unhide grouped rows. To unhide these rows, simply click on the box with the plus sign (+).
