Posts

How to hide and unhide rows in Microsoft Excel in 2 different ways

Just as you can quickly hide and unhide columns, you can hide or reveal hidden rows in your Excel spreadsheet as well.

In addition to freezing rows, you may find it helpful to conceal rows you are no longer using without permanently deleting the data from your spreadsheet. To later reveal the hidden cells, you can right-click to unhide individual rows.

You can also navigate to the “Format” option to unhide all hidden rows. This feature is especially helpful if you've hidden multiple rows throughout a large spreadsheet.

Here's how to do both.

Check out the products mentioned in this article:

Microsoft Office (From $139.99 at Best Buy)

MacBook Pro (From $1,299.99 at Best Buy)

Microsoft Surface Pro X (From $999 at Best Buy)

How to hide individual rows in Excel

1. Open Excel.

2. Select the row(s) you wish to hide. Select an entire row by clicking on its number on the left hand side of the spreadsheet. Select multiple rows by clicking on the row number, holding the “Shift” key on your Mac or PC keyboard, and selecting another.

3. Right-click anywhere in the selected row.

4. Click “Hide.”

Right-click to hide rows.

Marissa Perino/Business Insider

How to unhide individual rows in Excel

1. Highlight the row on either side of the row you wish to unhide.

2. Right-click anywhere within these selected rows.

3. Click “Unhide.”

Highlight adjacent cells to unhide a hidden row.

Marissa Perino/Business Insider

4. You can also manually click or drag to expand a hidden row. Hidden rows are indicated by a thicker border line. Move your cursor over this line until it turns into a double bar with arrows. Double click to reveal or click and drag to manually expand the hidden row or rows. (If you've hidden multiple rows, you may have to do this multiple times.)

How to unhide all rows in Excel

1. To unhide all hidden rows in Excel, navigate to the “Home” tab.

2. Click “Format,” which is located towards the right hand side of the toolbar.

3. Navigate to the “Visibility” section. You'll find options to hide and unhide both rows and columns.

4. Hover over “Hide & Unhide.”

5. Select “Unhide Rows” from the list. This will reveal all hidden rows, a feature especially helpful if you've hidden multiple rows throughout a large spreadsheet.

Unhide all rows.

Marissa Perino/Business Insider

Related coverage from How To Do Everything: Tech:

LEAVE YOUR COMMENT