Sometimes you want to have only a few editable cells available for the users in the worksheet and all other cells to be protected from editing.
For this, you have to use the lock cells option so that one can only edit, add, replace or remove the values in the editable cells, and your locked cells can remain protected.
Keyboard Shortcut to Lock Cells in the Excel
There is no direct keyboard shortcut to lock the cells but you can use the combination of two shortcuts to lock the cells as mentioned below:
Ctrl + 1
Alt → T → P → P
Steps to Lock Specific Cells or Range Using Keyboard Shortcut
- First, select the cells or range of cells that only you want to make editable to the users.
- After that, press the “Ctrl +1” keys together and you will get the “Format cells” dialog box opened.
- Now enter the “P” key to go to the “Protection” tab and then press the “Tab + Spacebar” keys together to untick the “Locked cells” box and press “Enter”.
- In the end, press “Alt → T → P → P” to open the “Protect Sheet” dialog box and enter the password, and press “Enter”.
- At this moment your sheet is protected except for the selected cells and users now can only edit, add, and replace the value only in those editable cells and other cells will be protected.
- Absolute Reference (Excel Shortcut)
- Add Column (Excel Shortcut)
- Copy and Paste (Excel Shortcut)
- Cut and Paste (Excel Shortcut)
- Delete Cell (Excel Shortcut)
- Delete Row(s) (Excel Shortcut)
- Edit Cell (Excel Shortcut)
- Insert Cell (Excel Shortcut)
- Insert – Add Row(s) (Excel Shortcut)
- Merge-Unmerge Cells (Excel Shortcut)
- Paste Values (Excel Shortcut)
- Select Row (Excel Shortcut)
- Transpose (Excel Shortcut)
- Unhide Columns (Excel Shortcut)
- Open Go To Option (Excel Shortcut)
⇠ Back to Excel Shortcut Keys (Cheat Sheet PDF)