Lock only a few cells on a worksheet - Help and How-to

Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Printer-Friendly Version

Lock only a few cells on a worksheet

Applies to: Microsoft Office Excel 2003

Applies to
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.

Related Office Online discussions

Read related questions and answers from other Microsoft Office customers.

Get Office 2007