How to Hide Rows in Excel: 6 Steps (with Pictures)

Table of contents:

How to Hide Rows in Excel: 6 Steps (with Pictures)
How to Hide Rows in Excel: 6 Steps (with Pictures)

Video: How to Hide Rows in Excel: 6 Steps (with Pictures)

Video: How to Hide Rows in Excel: 6 Steps (with Pictures)
Video: WordPress RSS Full Content WITH IMAGES 📸 (Step By Step) 2024, November
Anonim

By hiding unnecessary rows in Excel, you will find it easier to read the worksheet, especially if it is large enough. The hidden rows don't clutter the worksheet, but they do affect the formula. You can easily hide and unhide rows in any version of Excel by following these instructions.

Step

Method 1 of 2: Hiding a Set of Rows

Hide Rows in Excel Step 1
Hide Rows in Excel Step 1

Step 1. Use the row selector to highlight the rows you want to hide

You can press the Ctrl key to select multiple lines.

Hide Rows in Excel Step 2
Hide Rows in Excel Step 2

Step 2. Right-click inside the highlighted area

Select "hide". The rows will be hidden from the worksheet.

Hide Rows in Excel Step 3
Hide Rows in Excel Step 3

Step 3. Show rows

To reveal previously hidden rows, use the row selector to highlight rows above and below them. For example, select row 4 and row 8 if rows 5-7 are hidden.

  • Right-click within the highlighted area.
  • Select "unhide".

Method 2 of 2: Hiding a Group of Rows

Hide Rows in Excel Step 4
Hide Rows in Excel Step 4

Step 1. Create a group of rows

In Excel 2013, you can group/ungroup rows so that you can easily hide and unhide them.

  • Highlight the rows you want to group together and then click the “Data” tab.
  • Click the “Group” button in the “Outline” Group.
Hide Rows in Excel Step 5
Hide Rows in Excel Step 5

Step 2. Hide the row group

A line and a box with a minus sign (-) appear next to the lines. Click the box to hide the "grouped" rows. If the rows have been hidden, the small box will display a plus sign (+).

Hide Rows in Excel Step 6
Hide Rows in Excel Step 6

Step 3. Show rows

Click the (+) box if you want to show those rows.

Recommended: