Exam 77-888: Microsoft Excel Expert 2010

1. Sharing and Maintaining Workbooks

1.2. Apply protection and sharing properties to workbooks and worksheets

Review ->Changes-> Protect Sheet

Prepare to Share

Say you are ready to send this workbook around the office for comments and review. Before you send it around the office you may wish to consider if you should Share or Protect your work. Let's think about Protecting the data. When you Protect a sheet or workbook, you are restricting what users can or cannot do.

 

1. Try it: Protect the Sheet

Go to Review->Changes.

Select Protect Sheet.

 

What Do You See? You will be prompted to Protect worksheet and contents. By default, when you Protect a worksheet all of the cells will be locked. You can select which options you would allow your users to do, such as Insert row or Format cells.

 

You can enter a Password to unprotect the sheet, or not.

 

Click CANCEL and keep going, please.