To hide formulas in Excel, there are three methods: 1. Hide formulas through cell formatting and protect the worksheet; 2. Directly protect the worksheet from viewing formulas; 3. Hide the entire worksheet or use VBA to hide it very much. First, select the cell → Set cell format → check "Hide" in "Protect" and protect the worksheet; second, click "Review" → "Protect the worksheet" and set the password; finally, right-click the worksheet label and select "Hide" or use VBA to set it to xlSheetVeryHidden. Be careful to be both hiding and protection, and be sure to save your password to ensure that it is editable in the future.

Sometimes you may not want others to view or modify the formulas you write in Excel, such as making financial statements, budget tables, etc. At this time, hidden formulas become very useful.

Below I will share a few simple and practical methods to allow you to easily hide formulas in Excel.

? 1. Set hidden formulas through cell formatting

This is the most basic and most commonly used method. Excel allows you to set properties of a cell or region individually to make formulas invisible.

Operation steps:

• Select the cell containing the formula;
• Right-click → Set cell format (or use the shortcut key Ctrl 1);
• Switch to the "Protection" tab;
• Check the “Hide” option;
• Then click OK.

??Note: This setting will only take effect after the worksheet is "protected". That is to say, you need to click "Review" → "Protect Worksheet" in the menu bar and set a password (optional) so that others will not see the formula you are hiding.

?? 2. Protect the entire worksheet to prevent viewing formulas

If you have set "hidden" but have not protected the worksheet, others can still double-click the cell to see the formula. So this step is a must.

How to operate?

• Click the Review tab;
• Find the "Protect Worksheet" button;
• You can choose whether to set a password in the pop-up window;
• You can check the actions that are allowed to perform by users, such as selecting cells, sorting, etc.
• After clicking OK, the worksheet is locked.

In this way, even if others click on that cell, they cannot see the formula inside, and can only see the results.

? 3. Hide the entire worksheet to avoid formula leakage

If you don't want people to know that there is any data and formulas, you can even consider hiding the entire worksheet directly.

How to do it?

• Right-click on the worksheet tab at the bottom;
• Select Hide;
• If you want to resume display, right-click again → “Unhide”;
• If you want to hide deeper, you can set it to "very hidden" with VBA.

? If you want to use VBA, you can open the VBA editor (Alt F11) in the development tool, then right-click the worksheet → Properties → Change (Visible) to xlSheetVeryHidden . Hiding at this level can only be restored through VBA.

? Tips: Don’t forget your password!

If you set a protection password, remember to save it. If you can't open it one day, it's embarrassing. In addition, if it is just a shared form within the company, it is recommended to put the password in a safe place to facilitate collaboration.

Basically these methods are all, not complicated but it is easy to ignore details, especially the two steps of "hiding" and "protection" are indispensable. You can choose one or several combinations according to your needs.

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