Excel shortcuts

How to lock cells in excel shortcut

Locking cells in an Excel spreadsheet can prevent other users from accidentally or deliberately changing the data in those cells. It can also stop users from moving, inserting, or deleting cells that contain data. When you protect a sheet or workbook, all cells are locked by default, but you can choose to unlock specific cells or ranges of cells. If you do not protect the sheet or workbook, users can make any changes they want.

To lock cells or ranges of cells, you first need to select them. To select a single cell, click on it. To select a range of cells, click on the first cell in the range and then drag your mouse over the other cells you want to select. To select non-adjacent cells or ranges of cells, hold down the Ctrl key while you click on the cells or ranges you want to select.

Once you have selected the cells you want to lock, click the Format menu and then click on the Cells item. This will open the Format Cells dialog box. Click on the Protection tab and then check the Locked checkbox. You can also choose to hide the cells by checking the Hidden checkbox. If you do not want users to be able to see the formulas in the cells, check the Hide Formulas checkbox.

When you have finished making your selections, click on the OK button. The cells will now be locked and the locked status will be indicated by a locked padlock icon in the upper-left corner of the cells. To unlock cells, simply select them and then click on the Format menu and choose the Cells item. This will open the Format Cells dialog box. Click on the Protection tab and then uncheck the Locked checkbox. You can also choose to unhide the cells by unchecking the Hidden checkbox. If you do not want users to be able to see the formulas in the cells, uncheck the Hide Formulas checkbox.

When you have finished making your selections, click on the OK button. The cells will now be unlocked and the locked status will be indicated by an unlocked padlock icon in the upper-left corner of the cells.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.