How to hide cells in Excel – our guide to hiding rows and columns
Reviewed By: Kevin Pocock
Table of Contents
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.
How to hide cells in Excel
If you want to hide individual cells, follow these simple steps:
Step
Select the cells and go to Home
Select which cells you want to be hidden and then go to the Home tab.
Step
Go to Format
Next, click on Format and then select Format Cells.
Step
Go to Custom
Next, click on the Number tab and go to Custom.
Step
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.
How to hide rows in Excel
If you want to hide a whole row, follow these steps.
Step
Select a cell within a row
Choose a cell within a row and select it.
Step
Go to Format
Go to the Home tab and in the Cells group, click Format.
Step
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.
How to hide columns in Excel
You can also hide columns in an Excel spreadsheet. To do this, follow these steps.
Step
Select a cell within a column
Choose a cell within a column and select it.
Step
Go to Format
Go to the Home Command tab, go to the Cells group and click Format.
Step
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
About the Author