1. Select the cell (area) where you want to hide the content. To do the format → cell command, open the Format Cells dialog box, select the Custom option under categories in the Number tab, and then type ";;;" In the box below the right. (Semicolon in three English states).
2, and then switch to the "Protection" tab, select the "hidden" option, press the "OK" button to exit.
3, the implementation of "tools → protection → protection sheet" command, open the "Protect Sheet" dialog box, set a good password, "OK" to return.
After this setting, the contents of the above cells are no longer displayed, or the transparency features of Excel are not allowed to appear.
Tip: Under the Protection tab, do not clear the "∨" number in the check box before locking, so that you can prevent others from deleting your hidden data.