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.
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).
Or you can right-click and select Format Cells to open the Format Cells dialog box .
Then in the Number tab you select Custom in the Category and enter ;;; in the Type section and click OK as shown below:
Results after hiding the content of Cell:
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.
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.
Thus, cells with values matching the above values will be hidden.
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!