Document Protection

Excel's Document Protection features enable you to limit the types of changes others can make to a document. There are three types of protection:

  • Protect Sheet protects worksheet components:

    • Contents protects cells from changes.

    • Objects protects objects such as embedded charts and graphic objects from changes.

    • Scenarios protects scenarios from changes. (Scenarios is an advanced feature of Excel not covered in this book.)

  • Protect Workbook protects workbook components:

    • Structure prevents workbook sheets from being inserted, deleted, moved, hidden, unhidden, or renamed.

    • Windows protects workbook windows from being moved, resized, hidden, unhidden, or closed.

  • Protect and Share Workbook enables you to share the workbook but only with ...

Get Microsoft Excel X for Mac OS X: Visual QuickStart Guide 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.