1 / 25

Excel Lesson 16 Protecting, Tracking , and Sharing Workbooks

Excel Lesson 16 Protecting, Tracking , and Sharing Workbooks. Microsoft Office 2010 Advanced. Cable / Morrison. Objectives. Add password protection to a worksheet. Remove password protection from a worksheet. Add password protection to a workbook.

poppy
Download Presentation

Excel Lesson 16 Protecting, Tracking , and Sharing Workbooks

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Excel Lesson 16Protecting, Tracking, and Sharing Workbooks Microsoft Office 2010 Advanced Cable / Morrison

  2. Objectives • Add password protection to a worksheet. • Remove password protection from a worksheet. • Add password protection to a workbook. • Remove password protection from a workbook. • Enable the Track Changes feature. 2 2

  3. Objectives (continued) • Change a workbook with tracked changes. • Accept or reject tracked changes. • Disable the Track Changes feature. • Create a shared workbook. • Modify a shared workbook.

  4. Vocabulary • case sensitive • decrypt • disable • enable • encrypt • password • shared workbook 4 4

  5. Introduction • To protect Excel data from unwanted changes, you can add password protection to worksheets and workbooks. • The Track Changes feature can be enabled to keep track of the changes made in a workbook. • Shared workbooks allow multiple users to work in the same workbook at the same time.

  6. Adding Password Protection to a Worksheet • To prevent changes to a worksheet, you can protect it with a password. • A passwordrefers to a sequence of characters, known only by you, that is required for access to the file. • Passwords are case sensitive.

  7. Adding Password Protection to a Worksheet (continued) • Protect Sheet dialog box

  8. Removing Password Protection from a Worksheet • When a worksheet is password protected, changes cannot be made to it. • To make changes, you will need to remove the password protection. Unprotect Sheet dialog box

  9. Adding Password Protection to a Workbook • To prevent a workbook from being opened by an unauthorized person, you can password-protect a workbook. • When you password-protect a workbook, you are encrypting the file. • Encryptingmeans that the information in the file is scrambled.

  10. Adding Password Protection to a Workbook (continued) • Protect Workbook options

  11. Removing Password Protection from a Workbook • You can remove the password protection from a workbook as needed. • When you remove the password protection, you are decryptingthe workbook.

  12. Removing Password Protection from a Workbook (continued) • Encrypt Document dialog box

  13. Enabling the Track Changes Feature • The Track Changes feature shows changes made to an Excel worksheet. • Changed cells appear with a border • If the Track Changes feature is enabled, it makes the workbook a shared file. • You enablethe Track Changes feature using the Highlight Changes dialog box.

  14. Enabling the Track Changes Feature • Completed Highlight Changes dialog box

  15. Making Changes in a Workbook with Tracked Changes • A cell with a border around it indicates that a change has been made. • If you place your mouse pointer over the highlighted cell, a callout will appear showing more information about the change.

  16. Making Changes in a Workbook with Tracked Changes (continued) • Worksheet with tracked changes

  17. Accepting or Rejecting Tracked Changes • As you review changes made to cells, you can accept or reject the changes. • The Accept or Reject Changes dialog box allows you to do this • You can accept or reject each change one at a time or you can accept or reject all changes at once.

  18. Accepting or Rejecting Tracked Changes (continued) • Accept or Reject Changes dialog box

  19. Disabling the Track Changes Feature • The Track Changes feature can be disabled, when it is not needed any longer. • When you disableTrack Changes, the workbook will no longer be shared. • Before you disable the Track Changes feature, make sure that all the changes are reviewed, accepted, or rejected.

  20. Creating a Shared Workbook • The Share Workbook feature allows several people to work in a workbook simultaneously. • With a shared workbook, changes made by multiple users are tracked. • You can choose to accept or reject these changes.

  21. Creating a Shared Workbook (continued) • Advanced tab settings in the Share Workbook dialog box

  22. Modifying a Shared Workbook • When you make changes to a shared workbook, Excel keeps track of the changes. • You can accept or reject the changes. • The changes are not marked with a border as they are with the Track Changes feature.

  23. Summary In this lesson, you learned: • You can add password protection to a worksheet to prevent unwanted changes. • When password protection is no longer needed, you can remove it from a worksheet. • You can add password protection to an entire workbook.

  24. Summary (continued) • A password can be removed from the workbook. • You can track changes in a workbook by enabling the Track Changes feature. • The Track Changes feature keeps a history of the changes made. • You can accept or reject tracked changes.

  25. Summary (continued) • If you no longer need to track changes, you can disable the Track Changes feature. • Several users can use the same workbook at the same time with the Share Workbook feature enabled. • You can make changes to a shared workbook.

More Related