How to Hide Cells in Excel

How to hide cells in excel.

There are tons of ways you can hide/unhide rows or columns but can you hide the content of a single cell? It’s easy but a tricky one. Only a few people know how to completely hide the contents of a cell or a range of cells. In this tutorial, I’ll explain two different ways and I’m sure you will be amazed.

Procedure 1: You can change the font color to white or match with your background color and your content will be hidden. But if you click on that cell, you’ll be able the see the cell content in the formula bar. Now you can click on the data tab and checkmark the formula bar. This will hide the entire formula bar in excel. Now you if you can’t find the formula bar how can you see the content inside it?
To unhide the content, just reverse the procedure and your cell content will be visible.

Procedure 2: This is the actual trick that truly hides the content of any cells. We need to select the cell/cells that we want to hide. Then from the number group of home tab, click on the corner arrow. This will open up format cells window. You can also use the keyboard shortcut to open format cell window. Just press CTRL + 1 on your keyboard. Now click on the custom. In the text box where you have general, write three semi colon like this ;;;

This will hide the content of those selected cell. But still, you’ll find the content inside the formula bar. Now we’ll use another trick. From the format cell window click on protection tab while selecting those cells. Now uncheck Locked and Checkmark Hide. Click ok and close the window. Now go to the review tab. Click on Protect sheet. Now click ok and ok again. If you want to add password you can write and confirm the password. Once this done, you won’t be able to see the cell content inside the formula bar, Making it completely invisible.

To unhide the cell you need to first unprotect the sheet. Then you need to select those cells with hidden content. Now right click and select format cell. Go to protection tab and checkmark locked and uncheck hide. Now go to number tab from the Format cell window and select general. Click ok and done.

#Hide #Cell #Excel

Thanks for watching.
----------------------------------------------------------------------------------------
Support the channel with as low as $5
----------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial

Here goes the most recent video of the channel:

Playlists:

Social media:

[Exceltutorial]

Recommend WPS Office-Best FREE alternative to Microsoft Office, Download for Win & Mac & Mobile.