How to Completely Hide a Formula from View in Microsoft Excel

When you build a complex financial model or a proprietary data analysis spreadsheet in Microsoft Excel, the mathematical formulas you write are often the most valuable part of the entire document. If you need to share that spreadsheet with a client, a junior employee, or an external auditor, you might want them to see the final results (the numbers in the cells) without allowing them to see the underlying proprietary formulas that generated those results.

By default, whenever a user clicks on a cell containing a formula, that entire formula is exposed in the formula bar at the very top of the screen. To protect your intellectual property or simply prevent accidental tampering, you can instruct Excel to completely hide the formula from view while keeping the calculated result perfectly visible.

Hiding the Formulas

Hiding formulas in Excel is a two-step process. First, you must select the specific cells you want to hide, and then you must lock the entire worksheet to activate the protection.

1. Open your spreadsheet in Microsoft Excel.
2. Highlight all the specific cells that contain the formulas you want to hide. (You can hold the Ctrl key while clicking to select multiple, non-adjacent cells).
3. Right-click anywhere inside your highlighted selection.
4. From the pop-up context menu, select Format Cells….
5. A large configuration window will appear. Click on the Protection tab at the far right side of the top menu.
6. You will see two checkboxes: “Locked” and “Hidden”. Ensure the box next to Hidden is checked. (Leaving “Locked” checked ensures they also cannot edit the cell).
7. Click OK.

At this point, you will notice that the formulas are still visible in the formula bar. This is normal. The “Hidden” setting you just applied remains completely dormant until you turn on the master protection switch for the entire worksheet.

Activating the Worksheet Protection

To finalize the process and make the formulas actually disappear, you must protect the sheet.

1. Look at the ribbon menu at the very top of the screen and click on the Review tab.
2. In the “Protect” group, click the button labelled Protect Sheet.
3. A popup window will appear asking for a password. Type a strong, memorable password into the text box. (Warning: If you forget this password, Microsoft cannot recover it for you, and you will be permanently locked out of editing your own formulas).
4. Leave all the default checkboxes in the list below exactly as they are.
5. Click OK.
6. Excel will prompt you to type the password a second time to confirm you did not make a typo. Type it again and click OK.

The protection is now active. If you click on any of the cells you previously formatted as “Hidden”, the cell will still display the calculated number (e.g., “$5,000”), but the formula bar at the top of the screen will be completely blank, hiding your proprietary calculations from prying eyes.