Protecting Worksheets

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.

Note

For information about additional security issues in Excel, see Chapter 4.

By default, Excel locks (protects) all cells and charts, but the protection is unavailable until you click the Review tab on the Ribbon and click Protect Sheet to access the Protect Sheet dialog box, as shown in Figure 6-22. (You can also click the Format button on the Home tab and then click Protect Sheet.) The ...

Get Microsoft® Office Excel® 2007 Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.