Download Spreadsheets 2013

Spreadsheets 2013 User Manual
Tips: This protection for worksheet only works on locked cells. After setting the protection, all you have
to do is to save the file and the setting will go into effect.
If you want to cancel the worksheet protection, click Unprotect Sheet in the Review tab. Or you can try
the other way: Select Unprotect Sheet in the Format drop-down list in the Home tab.
Enter the password you have set and the entire worksheet will be as it was before you locked it.
8.5 Protect Workbook
Workbook protection can prevent altering the structure of the workbook, which includes deleting, moving,
hiding, unhiding, and renaming the worksheet. You cannot insert a new worksheet or move and adjust the
window either when the workbook has been protected.
The operation steps are shown as follows:
(1) Select the workbook you want to protect.
(2) Click Protect Workbook in the Review tab. Then the Protect Workbook dialogue box will open and
shown as below:
Figure 8.5-1 The Protect Workbook dialogue box
(3) Input the password, and then press OK.
(4) If you want to remove the protection on a workbook, click the Unprotect Workbook icon in the
Review tab, and then input the password to cancel the protection.
8.6 Share Workbook
If you want multiple users to edit a workbook at the same time, you can share your workbook, which
means to put the workbook under a shared directory—a web server for example. Then others can access
the shared workbook through the Internet. This feature makes it more effective and easier for multiple
users to edit a workbook simultaneously. The operation steps are as follows:
(1) Select the workbook you want to share.
(2) Click the Share Workbook icon in the Review tab. The Share Workbook dialogue box pops up.
172