Lock Cells To Protect Them In Excel. One column refuses to lock even though all the rest of the columns or cells are locking just fine in my document. On the Protection tab select the Locked check box and then click OK to close the popup.
Make sure the Protect worksheet and contents of locked cells option is checked. To do that choose the whole sheet right click and then select Format Cells then Protection then uncheck the Locked option and click okay. Once youre done close this window and return to the main Excel window.
In the opening Encrypt Cells dialog box type your password into both Password box and Confirm box select one of.
On the Home tab click the Format Cell Font popup launcher. Follow these steps to lock cells in a worksheet. Im trying to lock certain cells in order to protect the formulas so that users cannot change them. Alternatively you can use the keyboard shortcut Ctrl 1.