Thursday, August 16, 2012

How to Protect a Sheet in Microsoft Excel 2003


1. Access the sheet protection menu. To access this menu, scroll to the “Tools” tab on the command bar and select “Protection.” Under the sub-menu that opens, select “Protect Sheet.”
2. Set the sheet protect options. Make sure that you check the box labeled “Protect worksheet and contents of cells” to enable protection. Under the scroll menu in the middle of the sheet protection properties menu, you can check the corresponding boxes for the features you want disabled when unauthorized users are viewing the file.
3. Add a password to your worksheet. To add password to your worksheet, simply type it into the “Password” field.
4. Implement the sheet protection. To implement all of your protection changes, click the “OK” button.

Blogger news