Hide the contents of any Cell in Excel

Using Excel to calculate and process data, sometimes for certain data, you need to hide the content of the cell but the value of that cell is still used to calculate as usual. To know how to do this, you follow the article below.

The article shows you how to hide the contents of cells in Excel.

Step 1: First you select the cells to hide content.

Hide the contents of any Cell in Excel Picture 1

Step 2: In the Home tab , in the Font section, you change the font color to the background color of the Excel you are using (the default is white).

Hide the contents of any Cell in Excel Picture 2

Or you can right-click and select Format Cells to open the Format Cells dialog box .

Hide the contents of any Cell in Excel Picture 3

Then in the Number tab you select Custom in the Category and enter ;;; in the Type section and click OK as shown below:

Hide the contents of any Cell in Excel Picture 4

Results after hiding the content of Cell:

Hide the contents of any Cell in Excel Picture 5

Note: If you want to hide the duplicate values ​​of adjacent cells on a column, then you do the following:

As the example in the article given, you select (highlighted) from cell B6 to the end of the cell you want to hide the duplicate value.

Hide the contents of any Cell in Excel Picture 6

Then select Conditional Formatting -> New Ruler -> Use a formula to determine which cells to format then type the formula = B6 = B5 (with the rows you enter the corresponding formula) into the Format values ​​where this formula is true. Next, you click Format to format the font color as the background color of the sheet. After setup is complete you click OK to finish.

Hide the contents of any Cell in Excel Picture 7

Thus, cells with values ​​matching the above values ​​will be hidden.

Hide the contents of any Cell in Excel Picture 8

To hide the duplicate values ​​on a row you do the same thing as for hiding adjacent values ​​on a column.

In the framework of the article, I showed you 3 ways to hide the content of Cell in Excel. You can refer to the implementation.

Good luck!