How to Hide Rows in Excel | Beginner’s Guide

In this short tutorial, we’ll look at how to easily hide rows in an Excel spreadsheet.

This way, you’ll be able to keep the information you don’t want to share private from others.

Let’s get started!

I’ll show you two different methods to hide a row or rows in written and video format.

How to Hide Rows in Excel Video

Watch this video on YouTube.

Highlighting Rows in Excel

First, you need to highlight the row or rows you’d like to hide.

You can do this by clicking on the bar of numbers and selecting the row.

If you want to hide multiple rows, press the Shift key and click each of the rows you want to hide or use the Ctrl key if the rows don’t lie next to each other.

First Way How to Hide Rows in Excel

Once the desired rows are selected, use the right-click button to select the ‘Hide’ option.

The hidden rows are not visible on the screen or if printed, but they are not deleted.

You can unhide them at any time.

Second Way How to Hide Rows in Excel

Now let’s try the second method. Select the rows again, this time by dragging them, then go to the Home tab, Cells section, and use the Format button to access the Format menu.

Find the ‘Hide and Unhide’ option and select ‘Hide Rows’.

And you’re done!

So we have learned How to Hide Rows in Excel the next social step is to unhide them.

To learn how to unhide rows, check out the next tutorial from Sheet Leveller.

And if you want to learn Excel our complete guide section is the place to go that will help you use Excel like a boss!

Or do you want to master Excel Functions? Well, our Excel Function section is the perfect place to learn.