How to hide and lock formulas in Excel

Unprotect Sheet button.


Note. If you've hidden the formulas before protecting the workbook, you may want to uncheck the Hidden checkbox after unprotecting the worksheet. This won't have any immediate effect because the formulas start showing in the formula bar as soon as you've removed the worksheet protection. However, if you ever want to protect the same sheet in the future, but let the users see the formulas, make sure the Hidden attribute is not selected for those cells (select the cells with formulas, press Ctrl + 1 to open the Format Cells dialog, go to the Protection tab and remove a tick from the Hidden box).
This is how you can hide and lock formulas in Excel. In the next tutorial, we will discuss various ways to copy formulas and you will learn how to apply a formula to all cells in a given column in a click. I thank you for reading and hope to see you again soon!