Lock only a few cells on a worksheet

Important notice for users of Office 2003    To continue receiving security updates for Office, make sure you're running Office 2003 Service Pack 3 (SP3). The support for Office 2003 ends April 8, 2014. If you’re running Office 2003 after support ends, to receive all important security updates for Office, you need to upgrade to a later version such as Office 365 or Office 2013. For more information, see Support is ending for Office 2003.

Applies to
Microsoft Office Excel 2003
Microsoft Excel 97, 2000, and 2002
  1. 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).
  2. 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.

  1. Select just the cells you want to lock and repeat step 2, but this time select the Locked check box.
  2. 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.

Applies to:
Excel 2003