Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

How To Hide Cell Contents In Excel

Date:2021-10-11 Author:Sandra

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

It’s really simple and fast.  But you can tell there are hidden traces.

How To Hide Cell Contents In Excel

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

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

Choose Custom and type[ ;;; ] in the box, then hit OK.

How To Hide Cell Contents In Excel

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

It’s a cool approach.

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *