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

  • 0

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

Category : entrepreneur

  • You can hide and unhide rows in Excel by right-clicking, or reveal all hidden rows using the “Format” option in the “Home” tab.
  • Hiding rows in Excel is especially helpful when working in large documents or for concealing information you won’t need until later.
  • Visit Business Insider’s homepage for more stories.

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.”

How to unhide rows in Excel

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.”

How to unhide rows in Excel

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.

How to unhide rows in Excel

Unhide all rows.
Marissa Perino/Business Insider

Related coverage from How To Do Everything: Tech:

  • How to make a line graph in Microsoft Excel in 4 simple steps using data in your spreadsheet

  • How to add a column in Microsoft Excel in 2 different ways

  • How to hide and unhide columns in Excel to optimize your work in a spreadsheet

  • How to search for terms or values in an Excel spreadsheet, and use Find and Replace


About Author

Sammy Singh

Global VC, Founder, and entrepreneur extraordinaire as featured in Inc. Magazine, Bloomberg, and Forbes. Sammy Singh is a graduate of UCLA and Wharton School of Business as well as a former student of Loyola University of Chicago. Sammy is best known as a renowned financial technology global entrepreneur and has founded over 26 different firms across industry and all over the world. He is a venture capitalist,a TV/ Film actor, tax specialist, and marketing solutions strategist. Connect with Sammy Singh on social media below!

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.