How To Lock A Cell In Excel Formula. Select all the cells in the worksheet by pressing Ctrl A. On the Protection tab select the Locked check box and then click OK to close the popup.
Delete rows or columns. Select all the cells in the worksheet by pressing Ctrl A. Insert a blank Row between existing each Rows of data in Excel Step 2.
On the Home tab in the Alignment group click the small arrow to open the Format Cells popup window.
B2 You can add to lock cell A1. Select all cells with data on your excel sheet To unlock them Go to Format cells To uncheck the locked checkbox Choose ONLY the cells with formulas and protect them Put a lock on those cells With your desired password. Select the formula cell click on one of the cell reference in the Formula Bar and press the F4 key. A new window will open.