O'Reilly logo

2007 Microsoft® Office System Inside Out by Microsoft Corporation

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

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 12-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.

Figure 12-22. The ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required