Hide Formula in Excel

Updated on December 28, 2023
Article byJeevan A Y
Edited byAshish Kumar Srivastav
Reviewed byDheeraj Vaidya, CFA, FRM

How to Hide Formulas in Excel?

Hiding formulas in Excel is a method when we do not want them to be displayed in the formula bar when we click on a cell with formulas. We can format the cells, check the hidden checkbox, and then protect the worksheet. It will prevent the formula from displaying in the “Formula” tab. Only the result of the formula will be visible.

13 Easy Steps to Hide Formula in Excel (with Example)

–>> If you want to learn Excel and VBA professionally, then ​Excel VBA All in One Courses Bundle​ (35+ hours) is the perfect solution. Whether you’re a beginner or an experienced user, this bundle covers it all – from Basic Excel to Advanced Excel, Macros, Power Query, and VBA.

Let us understand the steps to hide formulas in Excel with examples.

You can download this Hide Formula Excel Template here – Hide Formula Excel Template

Step 1:

Following are the 13 steps that we can use to hide formulas in Excel:

  1. First, we must select the entire worksheet by pressing the shortcut key “Ctrl + A.”

    Hide Formulas in Excel Step 1

  2. Now, on any cell, right-click and select “Format Cells” or press “Ctrl + 1.”

    Hide Formulas in Excel Step 2

  3. Once the above option is selected, it may open the below dialog box and select “Protection.”

    Hide Formulas in Excel Step 3

  4. Once the “Protection” tab is selected, uncheck the “Locked” option.

    Hide Formulas in Excel Step 4

    As a result, this will unlock all the cells in the worksheet. Remember, this may unlock the cells in the active worksheet in all the remaining worksheets. It remains locked only.

  5. If we observe as soon as we unlock the cells, Excel will notify us of an error as “Unprotected Formula.”

    Hide Formulas in Excel Step 5

  6. Select only the formula cells and lock them. For example, we have three formulas in the worksheet, and we selected all three.

    Hide Formulas in Excel Step 6

  7. Now, we must open the “Format Cells, select the “Protection” tab, and check the “Locked” and “Hidden” options.

    Hide Formulas in Excel Step 7

    Note: If we have many formulas in the Excel worksheet, we want to select each one of them, then we need to follow the below steps.

  8. Now, press the F5 (shortcut key to “Go to Special”) and select “Special.”

    Hide Formulas in Excel Step 7.1

  9. Consequently, this will open up the below dialog box. Select “Formulas” and click “OK.” It would select all the formula cells in the worksheet.

    Hide Formulas in Excel Step 7.2

    Now, it has selected all the formula cells in the entire worksheet.

  10. Protect the sheet once the formula cells are selected, locked, and hidden. Then, go to the “Review” tab and “Protect Sheet.”

    Hide Formulas in Excel Step 8

  11. Click on the “Protect Sheet” in Excel, and the dialog box may open up. Select only “Select locked cells” and “Select unlocked cells.” Type the password carefully because we cannot edit those cells if we forget the password.

    Hide Formulas in Excel Step 9

  12. Click on the “OK” button. It will again ask us to confirm the password. Enter the same password again.

    Hide Formulas in Excel Step 10

  13. Click on the “OK.” Now, our Excel formulas are locked and protected with a password. Suppose we cannot edit the password without the password. Then, if we try editing the formula, Excel will show the below warning message for us. Also, the formula bar does not show anything.

    Hide Formulas in Excel Step 11

Things to Remember

Recommended Articles

This article has been a guide to Hide Formula in Excel. Here, we discuss how to hide formulas in Excel using the “Protection” tab to lock the cell and practical examples. You may learn more about Excel from the following articles: –