Excel hides formulas and other content is editable

Click the small triangle in the upper left corner of the worksheet to select the entire worksheet

After selection, the entire outer frame will appear blue, and the mouse Right-click on any key and the "Format Cells" box will appear

as shown in the figure. Select the "Protect" option. After clicking, keep the "Lock" and "Hide" hooks removed. , it looks like in the picture

After setting, click "OK", you can find that a small green triangle appears in the upper left corner of the cell of the original formula

At this time, select the "Review" item in the edit bar

Then select the formula cell, right-click and "Format Cells" will appear "

At this time, the "Protection" column appears again. Now, unlike just now, you need to check Lock and Hide, as shown in the figure:

After clicking "OK", you can find that the original small triangle is gone

Save this state and click "Protect" in the edit bar Worksheet" will pop up the Protect Worksheet dialog box. By the way, enter a password to confirm

, then enter the password to confirm, and then click OK Edit the formula cell and you will find that the original formula no longer appears

Moreover, when you try to modify its content , a warning

# will appear in the picture. If it is other cells, they can be modified at will. In this way, others cannot see or modify your formulas without the password

Recommended related articles and tutorials:excel tutorial

The above is the detailed content of Excel hides formulas and other content is editable. For more information, please follow other related articles on the PHP Chinese website!