How to Lock and Protect Cells in Excel
Justin Chan
|
24 steps
|
2 minutes
1
Click "Select All"
2
Right Click on any selected cell, for example, "F8".
3
Click "Format Cells..."
4
Click "Protection"
5
Click "Locked" to uncheck it.
6
Click "OK"
7
Click "Name Box"
8
Type "f13:f23 [[enter]]"
9
Right Click on any cell within the selected range, for e.g. "F16".
10
Click "Format Cells..."
11
Click "Locked" to check it.
12
Click "OK".
13
Right Click on the Worksheet Tab, for e.g. "Qn16"
14
Click "Protect Sheet..."
15
Click in "Password to unprotect sheet" window and type the password.
16
Type in the given password, "noedit".
17
Click "OK"
18
In the "Reenter password to proceed." window, retype the password.
19
Type "noedit" and press "[[Enter]]"
20
Click "A15"
21
Type "3 [[enter]]" to test if the cell is not locked.
22
Click "F15"
23
Type "5 [[enter]]" to test if the cell is locked.
24
Since it's locked, the error message will stop you from entering any value. Click "OK" to accept this.
