Microsoft Office Tutorials and References
In Depth Information
In addition to password protection for your files, Excel offers several features that you
can use to protect your work—workbooks, workbook structures, individual cells, graphic
objects, charts, scenarios, windows, and more—from access or modification by others. You
can also choose to allow specific editing actions on protected worksheets.
For information about additional security issues in Excel, see Chapter 4, “Security and privacy.”
By default, Excel locks (protects) all cells and charts, but the protection is unavailable until
you activate it. Click the Review tab on the ribbon, and click Protect Sheet to access the
Protect Sheet dialog box shown in Figure 6-22. (You can also click the Format button on
the Home tab and then click Protect Sheet.) The protection status you specify applies to the
current worksheet only.
After protection is turned on, you cannot change a locked item. If you try to change a
locked item, Excel displays an error message. As you can see in Figure 6-22, the Allow All
Users Of This Worksheet To list contains a number of specific editorial actions you can
allow even on protected worksheets. In addition to the options visible in Figure 6-22, you
can choose to allow users to sort, use Filter and PivotTable reports, and edit objects or
Figure 6-22 The Protect Sheet dialog box gives you pinpoint control over many common
Unlocking individual cells
If you click Protect Sheet without specifically unlocking individual cells, you lock every cell
on the worksheet by default. Most of the time, however, you don’t want to lock every cell.
For example, you might want to protect the formulas and formatting but leave particular