How to "lock" Excel worksheet? Tags: Excel 2003 How To Excel Windows XP Last response: May 8, 2012 10:17 AM in Windows XP Share 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 Register or log in to remove 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 Register or log in to remove Ask the community Publish Tom's Hardware>Forum>Windows XP>How to "lock" Excel worksheet?> Related ressources: ForumPCMCIA slots need more power??? HELP! ForumHow to stop Windows XP install from resuming? ForumHow to install screensaver ForumHow do I find out this info? Need to remove a file.... ForumHow to migrate my C-Drive (Active/Windows) to a new HDD ForumInternet Explorer 7 - How was your experience? ForumTrying to run "The 11th Hour" ForumAdobe Premiere 2.0 "Out Of Memory" Problem ForumHow to Restore Toshiba Protege M400 w/ Windows Tablet Editio ForumHas anyone used "Connected" backup software? More resources Read discussions in other Windows XP categories Configuration Customization Drivers Security Video !