How To Hide Cells In Excel

Hide the cells in your Excel spreadsheet with our guide

Kevin Pocock

Kevin Pocock

How To Hide Cells In Excel?

Last Updated on

Early Cyber Monday deals are starting to go live on Amazon & Best Buy. Big brands such as Lenovo and Samsung are also starting to offer Black Friday discounts early, with many more to follow.

Microsoft Excel is the go-to software for any companies or small businesses that need to keep track of their information. But information can change and you may have a whole row of information on your Excel spreadsheet that is no longer reliable. In this article, we’ll be showing you how you can hide these cells, and we’ll also show you how you can hide rows and columns.

1

How To Hide Cells

If you want to hide individual cells, follow these simple steps:

Step

1

Select Which Cells

Select which cells you want to be hidden.

Step

2

Home Command Then Format

Go to the Home Command tab and click Format.

Step

3

Format Cells

Now click Format Cells and the Format Cells dialog box will appear.

Step

4

Select Number Tab

Now, select the Number tab.

Step

5

Category Then Custom

Find Category and select Custom.

Step

6

Type Three Semicolons (;;;) On Type Text Box

Next, go to the Type Text box and type in three semicolons (;;;)

Step

7

Click Ok

Finally, click OK.

The cells you have selected will now be hidden and no longer be visible on your spreadsheet.

2

Redisplaying Cells

Just as you can hide all the cells, columns, and rows, you can also unhide them. Follow these steps to redisplay the cells:

Step

1

Select Cells

Select the cells you want to be redisplayed.

Step

2

Home Tab To Cells Group Then Select Format

Go to the Home tab and go into the Cells group and select Format.

Step

3

Select Format Cells

Select Format Cells and the Format Cells dialog box will appear.

Step

4

Select Number Tab

Now, select the Number tab.

Step

5

Category Then Select The Cells To Be Redisplayed

Go to Category and select the cells you want to be redisplayed.

Step

6

Click Ok

Finally, click OK.

3

How To Hide Rows

If you want to hide a whole row, follow these steps:

Step

1

Select A Cell Within A Row

Choose a cell within a row and select it.

Step

2

Format

Go to the Home Command tab and in the Cells group, click Format.

Step

3

Hide The Rows

In the Format menu, go to the Visibility section and select Hide & Unhide and then Hide Rows.

Step

4

The Row Is Hidden

The row will now be hidden and no longer visible on your spreadsheet.

There is a faster way you can hide rows too if you have to do this often.

All you have to do for this method is right-click on the row ID and select hide. The whole row will be hidden now.

4

Redisplaying Rows

To redisplay rows, follow these steps:

Step

1

Select One Cell

Select one cell from the two rows that surround the hidden row.

Step

2

Format The Cells Group

Go to the Home Command tab and in the Cells group, click Format.

Step

3

Unhide Rows

In the Format menu, go to the Visibility section and click Hide & Unhide > Unhide Rows.

5

How To Hide Columns

You can also hide columns in an Excel spreadsheet. To do this, follow these steps:

Step

1

Select A Cell

Choose a cell within a column and select it.

Step

2

Format Cells Group

Go to the Home Command tab, go to the Cells group and click Format.

Step

3

Hide Columns

Within the Format menu, go to the Visibility section and choose Hide & Unhide, followed by Hide Columns.

Step

4

Selected Column Is Now Hidden

Your chosen columns will now be hidden and won’t appear on your spreadsheet.

Like hiding rows, you can also hide columns in a faster way. Right-click on the column ID and click Hide.

6

Redisplaying Columns

To redisplay the columns you’ve hidden, follow these steps:

Step

1

Select At Least One Cell

First, you want to select at least one cell from both columns that are around the hidden column.

Step

2

Format Cells Group

Go to the Home Command tab and in the Cells group, click Format.

Step

3

Unhide Columns

Now in the Format menu, go to the Visibility menu and select Hide & Unhide > Unhide Columns.

Conclusion

Being able to hide certain cells, columns and rows can really help in saving you time and hassle when you need to update information on your spreadsheet.

The beauty of being able to hide the information is that you can unhide it just as easily, so you don’t have to worry about it being gone forever if you ever need it again!