In this article you will learn quick trick how to hide content of cell. This trick is really useful and easy. Even beginners can use this trick as well.
Preparation of cell
To quickly hide the contents of cells in Excel just use custom formatting in cell:
1. Click the cell which content you want to hide.
Formatting the cell
2. Use the keyboard shortcut CTRL +1. Dialog box appears.
3. Click Custom, go to Type field and enter the value ;;; (three semicolons).
4. Confirm by clicking OK.
5. The cell contents won't be visible. As you see the B2 cell looks empty.
6. Remember! Content of cell will be still visible in the Formula Bar! (when you select the cell).
Cell formatting
You can hide the content of a cell by formatting the font color to match the background color of the cell. To do this:
- Select the cell(s) that you want to hide.
- Right-click the selected cells and choose "Format Cells."
- Go to the "Font" tab and select the font color that matches the background color of the cell.
- Click "OK."
Note: The content of the cell will still be visible when selected, but will not be visible when not selected.
Data Validation
You can also hide the content of a cell by using data validation. To do this:
- Select the cell(s) that you want to hide.
- Right-click the selected cells and choose "Data Validation."
- In the "Data Validation" dialog box, go to the "Settings" tab.
- In the "Allow" field, select "Custom."
- In the "Formula" field, enter the formula "=FALSE."
- Click "OK."
Note: The content of the cell will not be visible in the cell, but will still be accessible in the formula bar.
Hide the Column or Row
You can also hide the entire column or row that contains the cell(s) you want to hide. To do this:
- Select the entire column or row that you want to hide.
- Right-click the selected column or row and choose "Hide."
Note: The content of the cell will not be visible, but the row or column will be hidden, making it harder to access.
In conclusion, hiding the content of a cell in Excel can be accomplished using a variety of methods. You can use cell formatting, a custom number format, data validation, or by hiding the entire column or row. Choose the method that works best for your needs, and keep in mind that while the content of the cell may be hidden, it will still be accessible in the formula bar.