Excel: What Happened? (Page 1) 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44

Prepare to Share

You may wish to consider if you should share or protect this data when you distribute a workbook to your colleagues.

 

Try it: Protect the Sheet

Go to Review->Changes.

Select Protect Sheet.

 

You will be asked to Protect locked cells. Your users can select the cells whether or not they are locked. You can choose if you will allow other options.

 

You can enter a Password or not.

Review ->Changes ->Protect Sheet

 

 

  Microsoft Excel 2007 Exam 77-602 Topic: 5. Collaborating and Securing Data

  5.2.1.  Protect workbooks and worksheets: Require passwords to open workbooks