Then, open the Format Cells dialog and uncheck the Locked option from the Protection tab. How do I lock a formula cell in Excel without protecting the sheet? To lock a formula cell and prevent ...

However, if you open a protected Excel file in the browser edition, you can see hidden formulas, but you can’t modify them. For most sheets, hiding formulas is overkill but easily implemented.