How to disable viewing formulas in Excel?

php editor Apple teaches you how to disable viewing formulas in Excel tables. By setting a worksheet protection password, you can effectively prevent others from viewing the formula and only the results. This protects data security and ensures that formulas are not maliciously modified. The following are the specific steps: First, select "File" - "Information" - "Protect Worksheet" - "Set Password", enter the password and confirm to complete the setting. In this way, you can easily protect Excel table formulas and make the data more secure and reliable.

For example, if you click Calculate before setting, the calculation formula will be displayed in the edit box. To prevent the formula from being displayed, you need to hide it.

First, select the data area to be hidden with the mouse, then right-click and select [Format Cells];

After the [Format Cells] dialog box pops up, click the [Protect] option, then check the [Hide] option on the page, and then click [OK];

Return to the main page, click [Protect Worksheet] in the [Review] option list in the menu bar;

After the dialog box pops up, click [OK] directly below to set the "hidden formula";

If you want to hide the formula and require a password to unhide it, you can set a password in the [Password to use when canceling worksheet protection] column, and then click [OK], so that the formula can only be seen after entering the correct password.

After the settings are completed, click the calculation result again, and you can see that the calculation formula is no longer visible in the edit box.

If you want to cancel the hiding later and make the calculation formula appear, you only need to click [Cancel Work Protection] under the [Review] option on the home menu, and the hiding will be cancelled.

If you also set a password when setting the hidden formula earlier, then after clicking [Undo Worksheet Protection], a dialog box will pop up. You need to enter the originally set password in the password field, and click [OK]. To unhide.

So setting a hidden formula also sets a password. Be sure to remember or save the password, because if you forget the password, you cannot undo the "hidden formula", and you will not be able to see the original calculation formula, and Excel does not "forget" Password" option, even the author himself cannot retrieve the password.

If we encounter this situation, we can use other tools to solve the problem. With the Pepsi Niu Excel password recovery tool, can directly remove the "hidden formula" password without a password.

Select the [Unrestriction] module in the tool, and then import the Excel table with "hidden formula" set to directly lift it.

Tool link: Pepsi Niu Excel Password Recovery Tool

The Excel table with "hidden formulas" removed will be saved as a new table, and the original Excel table will still exist. Click [Go to View] to find the new Excel table.

The above is the detailed content of How to disable viewing formulas in Excel?. For more information, please follow other related articles on the PHP Chinese website!