Sign in with
Sign up | Sign in
Your question

How to "lock" Excel worksheet?

Last response: in Windows XP
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?


More about : lock excel worksheet

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.
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
Related resources
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
May 8, 2012 10:17:27 AM

How to lock secure to folder