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.