Excel shortcuts

15 Keyboard Shortcuts to Lock Cells in Excel

If you work with large amounts of data in Microsoft Excel, you may find yourself in need of a way to lock cells to protect them from being modified. There are a few different ways to do this, but the quickest and most efficient way is to use a keyboard shortcut. In this article, we'll show you 15 different keyboard shortcuts that you can use to lock cells in Excel.

1. Ctrl + Shift + 1

This shortcut will lock all cells in the selected range. To use it, first select the cells that you want to lock, then press and hold the Ctrl and Shift keys, and finally press the 1 key. All of the cells in the selection will be locked.

2. Ctrl + Shift + 2

This shortcut will lock only the cells in the top row of the selection. To use it, select the cells that you want to lock, then press and hold the Ctrl and Shift keys, and finally press the 2 key. Only the cells in the top row of the selection will be locked.

3. Ctrl + Shift + 3

This shortcut will lock only the cells in the bottom row of the selection. To use it, select the cells that you want to lock, then press and hold the Ctrl and Shift keys, and finally press the 3 key. Only the cells in the bottom row of the selection will be locked.

4. Ctrl + Shift + 4

This shortcut will lock only the cells in the left column of the selection. To use it, select the cells that you want to lock, then press and hold the Ctrl and Shift keys, and finally press the 4 key. Only the cells in the left column of the selection will be locked.

5. Ctrl + Shift + 5

This shortcut will lock only the cells in the right column of the selection. To use it, select the cells that you want to lock, then press and hold the Ctrl and Shift keys, and finally press the 5 key. Only the cells in the right column of the selection will be locked.

6. Ctrl + Shift + 6

This shortcut will lock only the cells in the top-left corner of the selection. To use it, select the cells that you want to lock, then press and hold the Ctrl and Shift keys, and finally press the 6 key. Only the cells in the top-left corner of the selection will be locked.

7. Ctrl + Shift + 7

This shortcut will lock only the cells in the top-right corner of the selection. To use it, select the cells that you want to lock, then press and hold the Ctrl and Shift keys, and finally press the 7 key. Only the cells in the top-right corner of the selection will be locked.

8. Ctrl + Shift + 8

This shortcut will lock only the cells in the bottom-left corner of the selection. To use it, select the cells that you want to lock, then press and hold the Ctrl and Shift keys, and finally press the 8 key. Only the cells in the bottom-left corner of the selection will be locked.

9. Ctrl + Shift + 9

This shortcut will lock only the cells in the bottom-right corner of the selection. To use it, select the cells that you want to lock, then press and hold the Ctrl and Shift keys, and finally press the 9 key. Only the cells in the bottom-right corner of the selection will be locked.

10. Ctrl + Shift + A

This shortcut will lock all cells in the worksheet. To use it, press and hold the Ctrl and Shift keys, and then press the A key. All cells in the worksheet will be locked.

11. Ctrl + Shift + B

This shortcut will lock only the cells in the first column of the worksheet. To use it, press and hold the Ctrl and Shift keys, and then press the B key. Only the cells in the first column of the worksheet will be locked.

12. Ctrl + Shift + C

This shortcut will lock only the cells in the first row of the worksheet. To use it, press and hold the Ctrl and Shift keys, and then press the C key. Only the cells in the first row of the worksheet will be locked.

13. Ctrl + Shift + D

This shortcut will lock only the cells in the last column of the worksheet. To use it, press and hold the Ctrl and Shift keys, and then press the D key. Only the cells in the last column of the worksheet will be locked.

14. Ctrl + Shift + E

This shortcut will lock only the cells in the last row of the worksheet. To use it, press and hold the Ctrl and Shift keys, and then press the E key. Only the cells in the last row of the worksheet will be locked.

15. Ctrl + Shift + F

This shortcut will lock only the cells in the first cell of the worksheet. To use it, press and hold the Ctrl and Shift keys, and then press the F key. Only the cells in the first cell of the worksheet will be locked.

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.