To lock a formula cell and prevent editing in it in Microsoft Excel, you are required to lock the cell as well as activate sheet protection. However, if you want, ...

To make your cell non-editable in Excel, you have to lock the cell and use a password to protect the information. Learn how!

Locking cells in a Microsoft Excel spreadsheet is among the most commonly used functions. Here’s a guide on how to lock cells in Excel.

First, select the cells with formulas you want to hide and protect, cells E4:E7 in our example sheet. Right-click the selection and choose Format Cells from the resulting submenu.

There is actually an easy way to lock in parts of your formula so only the correct parameters change. Watch to learn how to use the $ sign to lock in formulas. Produced by Daniel Goodman ...