There are several ways to hide rows or columns. The simplest is to select the columns or rows and click Hide like below.
![How To Hide Cell Contents In Excel How To Hide Cell Contents In Excel](https://www.myofficetricks.com/wp-content/uploads/2021/10/image.png)
It’s really simple and fast. But you can tell there are hidden traces.
![How To Hide Cell Contents In Excel How To Hide Cell Contents In Excel](https://www.myofficetricks.com/wp-content/uploads/2021/10/image-1.png)
If there is important data, how do we hide it so that it is not so easy to find?
![How To Hide Cell Contents In Excel How To Hide Cell Contents In Excel](https://www.myofficetricks.com/wp-content/uploads/2021/10/image-2.png)
We first select the area we want to hide and right-click to choose Format Cells in the list.
![How To Hide Cell Contents In Excel How To Hide Cell Contents In Excel](https://www.myofficetricks.com/wp-content/uploads/2021/10/image-3.png)
Choose Custom and type[ ;;; ] in the box, then hit OK.
![How To Hide Cell Contents In Excel How To Hide Cell Contents In Excel](https://www.myofficetricks.com/wp-content/uploads/2021/10/image-4.png)
The contents in this area are gone.
Just need to change the Format into General of this area to make the content reappear.
![How To Hide Cell Contents In Excel How To Hide Cell Contents In Excel](https://www.myofficetricks.com/wp-content/uploads/2021/10/image-5.png)
It’s a cool approach.
Leave a Reply