How to "lock" Excel worksheet?

Tags:

Last response: May 8, 2012 10:17 AM in Windows XP

inquiring

January 2, 2007 9:57:16 PM

Whats the best way to lock an entire worksheet in MS Excel 2003 so that ONLY the worksheet creator can make changes to the values in each cell?

Thanks.

More about : lock excel worksheet

| E-mail me updates
| Report abuse

exit2dos

January 2, 2007 10:10:01 PM

Click on Tools -> Protection. From here, you can select whether to protect the sheet, the workbook or to protect and share the workbook.

Each option has a box to put in a password.

| Report abuse

Anonymous

May 20, 2010 7:58:43 AM

OK I agree with that trick but, if we want only color format is locked and rest function will open to edit for user.

Please give reply

| Report abuse

goodtom

May 21, 2010 3:36:10 AM

In the "Review" tab, click on the "Protect sheet"

I also recommend doing "Protect workbook" to lock the visibility of the sheet

| Report abuse

dasa_007

May 8, 2012 10:17:27 AM

How to lock secure to folder

| Report abuse

Ask the community

Related ressources:

Read discussions in other Windows XP categories