Excel shortcuts

15 Keyboard Shortcuts for Locking Cells in Excel

If you work with data in Excel, you know how important it is to keep your cells locked. Whether you're working with a shared workbook or simply want to protect your data from accidental changes, locking cells is a crucial part of maintaining your spreadsheet.

While you can always lock cells manually, it's much faster to use a keyboard shortcut. In this article, we'll show you 15 keyboard shortcuts for locking cells in Excel.

1. Ctrl+1

The first keyboard shortcut is also the easiest to remember: Ctrl+1. This shortcut will open the Format Cells dialog box, where you can select the Protection tab. From here, you can check the "Locked" box to lock the selected cells.

2. Ctrl+A

If you want to lock all cells in a worksheet, use the Ctrl+A shortcut. This shortcut will select all cells in the worksheet, so you can then use the Ctrl+1 shortcut to open the Format Cells dialog box and lock the cells.

3. Ctrl+Shift+A

If you want to lock all cells except for the header row, use the Ctrl+Shift+A shortcut. This shortcut will select all cells in the worksheet except for the header row, so you can then use the Ctrl+1 shortcut to open the Format Cells dialog box and lock the cells.

4. Ctrl+B

If you want to lock only the header row, use the Ctrl+B shortcut. This shortcut will select the header row, so you can then use the Ctrl+1 shortcut to open the Format Cells dialog box and lock the cells.

5. Ctrl+Shift+B

If you want to lock all cells except for the header row and the first column, use the Ctrl+Shift+B shortcut. This shortcut will select all cells in the worksheet except for the header row and the first column, so you can then use the Ctrl+1 shortcut to open the Format Cells dialog box and lock the cells.

6. Ctrl+C

If you want to lock only the first column, use the Ctrl+C shortcut. This shortcut will select the first column, so you can then use the Ctrl+1 shortcut to open the Format Cells dialog box and lock the cells.

7. Ctrl+Shift+C

If you want to lock all cells except for the header row and the first two columns, use the Ctrl+Shift+C shortcut. This shortcut will select all cells in the worksheet except for the header row and the first two columns, so you can then use the Ctrl+1 shortcut to open the Format Cells dialog box and lock the cells.

8. Ctrl+D

If you want to lock only the first two columns, use the Ctrl+D shortcut. This shortcut will select the first two columns, so you can then use the Ctrl+1 shortcut to open the Format Cells dialog box and lock the cells.

9. Ctrl+Shift+D

If you want to lock all cells except for the header row and the first three columns, use the Ctrl+Shift+D shortcut. This shortcut will select all cells in the worksheet except for the header row and the first three columns, so you can then use the Ctrl+1 shortcut to open the Format Cells dialog box and lock the cells.

10. Ctrl+E

If you want to lock only the first three columns, use the Ctrl+E shortcut. This shortcut will select the first three columns, so you can then use the Ctrl+1 shortcut to open the Format Cells dialog box and lock the cells.

11. Ctrl+Shift+E

If you want to lock all cells except for the header row and the first four columns, use the Ctrl+Shift+E shortcut. This shortcut will select all cells in the worksheet except for the header row and the first four columns, so you can then use the Ctrl+1 shortcut to open the Format Cells dialog box and lock the cells.

12. Ctrl+F

If you want to lock only the first four columns, use the Ctrl+F shortcut. This shortcut will select the first four columns, so you can then use the Ctrl+1 shortcut to open the Format Cells dialog box and lock the cells.

13. Ctrl+Shift+F

If you want to lock all cells except for the header row and the first five columns, use the Ctrl+Shift+F shortcut. This shortcut will select all cells in the worksheet except for the header row and the first five columns, so you can then use the Ctrl+1 shortcut to open the Format Cells dialog box and lock the cells.

14. Ctrl+G

If you want to lock only the first five columns, use the Ctrl+G shortcut. This shortcut will select the first five columns, so you can then use the Ctrl+1 shortcut to open the Format Cells dialog box and lock the cells.

15. Ctrl+Shift+G

If you want to lock all cells except for the header row and the first six columns, use the Ctrl+Shift+G shortcut. This shortcut will select all cells in the worksheet except for the header row and the first six columns, so you can then use the <

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.