Last Updated on
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.
How To Hide Cells
If you want to hide individual cells, follow these simple steps:
Step
Select Which Cells
Select which cells you want to be hidden.
Step
Home Command Then Format
Go to the Home Command tab and click Format.
Step
Format Cells
Now click Format Cells and the Format Cells dialog box will appear.
Step
Select Number Tab
Now, select the Number tab.
Step
Category Then Custom
Find Category and select Custom.
Step
Type Three Semicolons (;;;) On Type Text Box
Next, go to the Type Text box and type in three semicolons (;;;)
Step
Click Ok
Finally, click OK.
The cells you have selected will now be hidden and no longer be visible on your spreadsheet.
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
Select Cells
Select the cells you want to be redisplayed.
Step
Home Tab To Cells Group Then Select Format
Go to the Home tab and go into the Cells group and select Format.
Step
Select Format Cells
Select Format Cells and the Format Cells dialog box will appear.
Step
Select Number Tab
Now, select the Number tab.
Step
Category Then Select The Cells To Be Redisplayed
Go to Category and select the cells you want to be redisplayed.
Step
Click Ok
Finally, click OK.
How To Hide Rows
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
Format
Go to the Home Command tab and in the Cells group, click Format.
Step
Hide The Rows
In the Format menu, go to the Visibility section and select Hide & Unhide and then Hide Rows.
Step
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.
Redisplaying Rows
To redisplay rows, follow these steps:
Step
Select One Cell
Select one cell from the two rows that surround the hidden row.
Step
Format The Cells Group
Go to the Home Command tab and in the Cells group, click Format.
Step
Unhide Rows
In the Format menu, go to the Visibility section and click Hide & Unhide > Unhide Rows.
How To Hide Columns
You can also hide columns in an Excel spreadsheet. To do this, follow these steps:
Step
Select A Cell
Choose a cell within a column and select it.
Step
Format Cells Group
Go to the Home Command tab, go to the Cells group and click Format.
Step
Hide Columns
Within the Format menu, go to the Visibility section and choose Hide & Unhide, followed by Hide Columns.
Step
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.
Redisplaying Columns
To redisplay the columns you’ve hidden, follow these steps:
Step
Select At Least One Cell
First, you want to select at least one cell from both columns that are around the hidden column.
Step
Format Cells Group
Go to the Home Command tab and in the Cells group, click Format.
Step
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!