|Microsoft Office Excel 2003
Microsoft Excel 97, 2000, and 2002
- Select the entire worksheet by clicking the Select All button (the gray rectangle directly above the row number for row 1 and to the left of column letter A).
- Click Cells on the Format menu, click the Protection tab, and then clear the Locked check box.
This unlocks all the cells on the worksheet
Note If the Cells command is not available, parts of the worksheet may already be locked. On the Tools menu, point to Protection, and then click Unprotect Sheet.
- Select just the cells you want to lock and repeat step 2, but this time select the Locked check box.
- On the Tools menu, point to Protection, click Protect Sheet, and then click OK.
Note In the Protect Sheet dialog box, you have the option to specify a password and select the elements that you want users to be able to change. See Protect worksheet or workbook elements for more information.