Home> Topics> excel> body text

Excel hides formulas and other content is editable

王林
Release: 2019-12-20 11:42:05
Original
4147 people have browsed it

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

Excel hides formulas and other content is editable

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

Excel hides formulas and other content is editable

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

Excel hides formulas and other content is editable

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

Excel hides formulas and other content is editable

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

Excel hides formulas and other content is editable

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

Excel hides formulas and other content is editable

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

Excel hides formulas and other content is editable

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

Excel hides formulas and other content is editable

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

Excel hides formulas and other content is editable

Excel hides formulas and other content is editable

, 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

Excel hides formulas and other content is editable

Excel hides formulas and other content is editable

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

Excel hides formulas and other content is editable

# 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

Excel hides formulas and other content is editable

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!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!