Hide the data of a specific cell in excel

Suppose you have a confidential data in your worksheet. you do not want to get it visible on the worksheet when other user using that sheet. If that the case then you can hide those confidential data by using custom number format.

STEPS :

1. Select data which you want to hide.
2. Right click on it.
3. Click on format cells…

4. In the format cell dialogue box, go on “Number” tab

5. Click “Custom”

6. Type ;;; (3 semicolon) in the type box.

7. Click ok.

8. See the Result in below Image. The Data of the Selected Cells are hidden.

---

Unhide the data of a specific cell in excel

STEPS :

1. Select the cells whose data you want to Unhide.
2. Right click on it.
3. Click on format cells…
4. In the format cell dialogue box, go on “Number” tab
5. Click “Custom”
6. Choose “General” from the dropdown.
7. Click OK