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!
You should read it
- Types of data hiding in Excel - Part 2: How to hide cells, overflow text
- Complete tutorial of Excel 2016 (Part 5): Basics of cells and ranges
- How to hide formulas in Excel
- How to Subtract in Excel
- How to hide and hide sheets in Excel and show them again
- Types of data hiding in Excel - Hide pictures, graphs, rows, columns
- Turn off turn on the character repeat function in Excel
- Some experience in Excel spreadsheets
- Add a checkbox to the Excel spreadsheet
- Instructions to delete 0, hide 0 in Excel
- Ways to hide data on Excel
- Types of data hiding in Excel - Part end: Hide Excel Files
May be interested
Instructions for copying formulas and data between Excel tables
Comments in Excel - Create comments in Excel
How to hide and hide any text in Word
Copy and move text quickly in Word with the Shift key
Change the direction of text in Word
How to find the position of an open Word file - Display the location of the open file in Word