Review->Changes-> Protect and Share

Protect and Share

If you are editing this workbook in a group or department, you can Protect and Share your workbook. Here are the steps.

 

5. Try it: Protect and Share
Go to Review->Changes.
Select Protect and Share.


What Do You See? When you Protect and Share a Workbook, this option turns on the Tracking and prevents folks from turning the Tracking off.

 

What Else Do You See? You can enter a Password as well. The Password is optional.

 

When you click OK this workbook will be Shared. Click OK and keep going...

 

Exam 77-888: Microsoft Excel Expert 2010

1. Sharing and Maintaining Workbooks

1.2. Apply protection and sharing properties to workbooks and worksheets.