Hide Content Of A Cell In Excel

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

Capture

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

Capture




Now the format is applied and the content is hidden.

Hope this helped.

 

Share The Knowledge

Random Posts

Leave a Reply