Protect Formulas In Excel. Say you want to lock cell e2 to remain constant as you copy the formula to adjacent cells. The button text displays the opposite of the current state.
Check the locked option in excel. It says protect sheet when the sheet is unprotected and unprotect sheet when it is protected. In the format cells dialog box select the protection tab.
How to lock formulas in excel.
Select the cell with formulas that you want to lock press ctrl 1. Say you want to lock cell e2 to remain constant as you copy the formula to adjacent cells. There are different ways to do it. Select the cell with formulas that you want to lock press ctrl 1.
