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.

So enter this formula into a cell off to the side of your spreadsheet matrix (such as cell F2): =FORMULATEXT(E2) and Excel displays the actual formula of E2. Averages are used every day to ...