How to Lock and Hide Formula in Excel

Formulas and functions are two of Excel's most powerful tools. We use them from time to time. They have a significant impact on the efficiency of your calculation. There has to be some form of security issue when we're talking about one of the most powerful aspects. Yes, there are two of them in this circumstance.

1. We don't want anyone else to know about our formula.

2. We must prevent people from mistakenly or intentionally altering or removing our formulas.

If you like, you can address these problems separately. You can, for example, hide your formula if you don't want people to see it. You can secure your formula if you don't want people to modify or delete it.

However, there are occasions when we need to lock and hide formulas in Excel while still allowing input into other cells. You'll find a detailed step-by-step technique for protecting and hiding formulas in Excel in this post.

We need to select the full worksheet first, which we can do by hitting CTRL+A. A cell or a range of cells can be selected in a variety of ways. If you want to understand more about it, watch this video tutorial: Excel- Selecting Cells 

Select the worksheet and then go to the "Home" tab, "Format," and "Format Cells."

A popup will now appear, and you must select the "Protection" tab from the popup.

Uncheck both the "Locked" and "Hidden" checkboxes and click OK. By default, Excel locks all of the cells. This will allow us to keep all of the cells that aren't filled with a formula open.

Now we must pick all of the cells that contain the formula. Select "Find & Select" from the home tab. Now select "Go to Special" from the drop-down menu. Select “formula” from the popup now. You're done when you click OK. All of the cells with formulas have now been picked. Now we need to protect and hide the formula in these cells.

After you've made your formula selections, go to the "Home" tab, "Format," and then "Format Cells." A popup will now appear, and you must select the "Protection" tab from the popup. Now select "Locked" and "Hidden" from the drop-down menus and click OK.

Finally, go to the review tab and choose "Protect Sheet" from the drop-down menu. Now type the password twice and hit the OK button. This is how you can lock and hide Excel formula without securing the entire document. Thank you so much for taking the time to read this far. 

If you can, please support us by becoming a Patron. Thanks a million in advance.