Select the cell with formulas that you want to lock Press Ctrl 1 Step 2. Lock and Unlock Specific Cells or Ranges Right-click on the cell or range you want to change and choose Format Cells from the menu that appears. Usually you wont want to disable the Formula bar unless viewers are working with a read-only file.
The process of adding to the front of rows or columns is known as anchoring and it is compatible with all versions of Excel.
Lock and protect formulas with Format Cells and Protect Sheet functions 1. This procedure also prevents the cells that contain the formula from being edited. Click Protection and unchecked the Locked option. This will bring up the Format Cells window keyboard shortcut for this window is Ctrl 1.