Microsoft Office Tutorials and References
In Depth Information
Putting on the Protection
the cells that contain headings and formulas but allow changes in all the cells
where you enter the budgeted amounts. That way, you can’t inadvertently
wipe out a title or formula in the worksheet simply by entering a value in the
wrong column or row (a common occurrence).
To leave certain cells unlocked so that you can still change them after
protecting the worksheet or workbook, select all the cells as the cell selection, open
the Format Cells dialog box (Ctrl+1), and then click the Locked check box on
the Protection tab to remove its check mark. Then, after unlocking the cells that
you still want to be able to change, protect the worksheet as described earlier.
To remove protection from the current worksheet or workbook document so
that you can again make changes to its cells (whether locked or unlocked),
click the Unprotect Sheet or the Unprotect Workbook command button in the
Changes group on the Ribbon’s Review tab (or press Alt+RPS and Alt+RPW,
respectively). If you assign a password when protecting the worksheet or
workbook, you must then reproduce the password exactly as you assigned
it (including any case differences) in the Password text box of the Unprotect
Sheet or Unprotect Workbook dialog box.
You can also protect a worksheet or your workbook from Excel Info screen
in the Backstage by clicking the Protect Workbook button (Alt+FIP). Clicking
this button opens a menu of protection options, including among others, the
familiar Protect Current Sheet to prevent changes to the current worksheet
in the Protect Sheet dialog box and Protect Workbook Structure to changes
to worksheets and or windows set up in the current workbook in the Protect
Structure and Windows dialog box.
To protect and share . . .
If you create a workbook with contents updated
by several users on your network, you can use
the Protect and Share Workbook command
button in the Changes group of the Review
tab (Alt+RO) to ensure that Excel tracks all the
changes made and that no user can
intentionally or inadvertently remove Excel’s tracking
of the changes made. To do this, simply select
the Sharing with Track Changes check box in
the Protect Shared Workbook dialog box that
appears after you click the command button.
After you select this check box, you can add
a password in the Password (Optional) text
box below that each user must supply before
he or she can open the workbook to make any
changes. Then click OK or press Enter.