Hide Content Of A Cell In Excel

Let’s see how to hide the content of a cell in excel.

Suppose we want to hide the content in the above data range, they will still exist in the cells but will not be visible.

Select The Data and press Ctrl+1 to open the format dialogue box and enter three semicolons in the Custom Type, press OK

Now the format is applied and the content is hidden.

Hope this helped.

Share The Knowledge

Remove Column Headers/Row Headers In Excel
Column headers are the alphabetical character which is displayed in the column header and row headers are the numeric digit […]

Share The Knowledge
Highlight Cells With Value Lower Than Average Value Of The Column In Excel
Let’s see how we could highlight the cells having value lower than the average value of that column in excel. […]

Share The Knowledge
Sum Of Digits In A Cell In Excel
We will see in this post one of the easiest way to sum up all the digits in a number […]

Share The Knowledge
Find Factorial In Excel
Let’s see how to calculate the factorial of a given number in excel.There is a inbuilt function called FACT available […]

Share The Knowledge