• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL

Chapter 16. Sharing Workbooks > Protecting Your Data

Protecting Your Data

When working in a sharing environment or if you're afraid others might be able to view your data without permission, you can assign passwords to protect entire workbooks, individual worksheets, or specific cell ranges from changes.

To protect a workbook or worksheet

If the workbook is currently open in shared mode, temporarily disable sharing by following the tip at the end of “Sharing Workbooks on a Network,” earlier in this chapter.

Do one of the following:

  • To protect the current sheet, choose Tools > Protection > Protect Sheet (Figure 16.13).

    Figure 16.13. The Protect Sheet dialog box.

  • To protect an entire workbook, choose Tools > Protection > Protect Workbook (Figure 16.14).

    Figure 16.14. The Protect Workbook dialog box.

  • To simultaneously protect a workbook and enable sharing, choose Tools > Protection > Protect and Share Workbook (Figure 16.15).

    Figure 16.15. The Protect Shared Workbook dialog box.

Click the check boxes of the elements you wish to protect.

Optional: To add password protection to the worksheet or workbook, enter a password in the text box.

A password is an additional layer of protection. In addition to preventing the changes specified in Step 3, each user must supply the password whenever accessing the worksheet or workbook.

Click OK to dismiss the dialog box and enact the new protection settings.

If you assigned a password, you'll be prompted to re-enter it.



Not a subscriber?

Start A Free Trial

  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint