Browse » Home
Thursday, February 23, 2012
How to Protect Sales in Excel 2007
Protect an Entire Worksheet
1. Click on the bottom tab to select the worksheet that you wish to protect.
2. Click on the 'Review' tab on the menu ribbon.
3. Click 'Protect Sheet' in the 'Changes' panel of the 'Review' tab.
4. Enter a password if you want the worksheet to be password-protected. If not, leave the 'Password to unprotect sheet' box blank.
5. Click the 'OK' button and the entire worksheet will be protected from future changes.
Protect Cells Within a Worksheet
6. Click on the bottom tab of the worksheet you want to protect.
7. Click-and-drag the cursor to select the cells containing the data you wish leave unprotected. You can also hold the 'Ctrl' key down and click on multiple individual cells. Entire rows or columns can also be selected.
8. Click the 'Home' tab and then click 'Format Cells.' You can also right-click on a selected cell and select 'Format Cells' from the contextual menu.
9. Click 'Protection' and then uncheck the 'Locked' option.
10. Click 'OK' to apply the changes and close the dialog window.
11. Click on the 'Review' tab and then click on 'Protect Sheet.'
12. Enter a password for the worksheet if desired. Leave the input box blank if you don't want to password-protect the worksheet cells.
13. Click the 'OK' button. All cells except the ones selected in Step One will be protected from future changes.