How to hide cells in Excel – our guide to hiding rows and columns

Last Updated on February 13, 2024

If you want to know how to hide cells in Excel, we’ve got you covered right here.

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 specific cells in Excel, or how you can quickly hide entire rows or columns.

So, without any further ado, let’s dive into how you can hide a cell in Excel.

1

How to hide cells in Excel

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

Step

1

Select the cells and go to Home

Select which cells you want to be hidden and then go to the Home tab.

Step

2

Go to Format

Next, click on Format and then select Format Cells.

Step

3

Go to Custom

Next, click on the Number tab and go to Custom.

Step

4

Enter three semicolons to hide the cells

In the Type: box, type in three semicolons (;;;) and click on OK. Once done, the cells will be hidden.

2

How to hide rows in Excel

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

Go to Format

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

Step

3

Hide the rows

In the Format drop-down menu, go to the Visibility section, click on Hide & Unhide, and then select Hide Rows. This will hide the row.

3

How to hide columns in Excel

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

Step

1

Select a cell within a column

Choose a cell within a column and select it.

Step

2

Go to Format

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

Step

3

Hide the column

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

Conclusion

Being able to hide certain cells, columns, and rows can really help save 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!

Learn more about Excel and its features through these in-depth helpful guides:

• How to make a line graph in Microsoft Excel
• How to go to the next line in Excel
• How to clear formatting in Excel