English Deutsch Français Italiano Español Português 繁體中文 Bahasa Indonesia Tiếng Việt ภาษาไทย
All categories

3 answers

Lock only a few cells on a worksheet
source: Help, in Excel
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.
3. Select just the cells you want to lock and repeat step 2, but this time select the Locked check box.
4. 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.

2007-09-03 15:59:53 · answer #1 · answered by TheHumbleOne 7 · 2 0

I agree with the first answer..I've tried it and it works. Great dude! Ü

2007-09-03 23:07:59 · answer #2 · answered by i a 4 · 0 0

tools---->protection--->protect sheet--->then type in your password---->save

2007-09-03 16:14:59 · answer #3 · answered by Echizen 2 · 0 0

fedest.com, questions and answers