Page 38 - Excel Data Analysis

02 537547 Ch01.qxd 3/4/03 11:45 AM Page 24

EXCEL DATA ANALYSIS

PROTECT WORKSHEETS

f you intend to share your worksheet with other users, users can perform while the worksheet is protected. There
you may want to password protect it to ensure that are fifteen different options from which to choose,
I users cannot alter values in individual cells. By including locking and unlocking cells, formatting, and
protecting the worksheet, you ensure that the integrity of inserting or deleting cells. If a user attempts to perform a
the data remains intact, no matter who views the worksheet task that is not allowed, Excel displays a message box
contents. indicating that the worksheet is protected. In order for
users to make any modifications to a protected worksheet,
To protect a worksheet, you use the Protect Sheet dialog they must unprotect the worksheet with the appropriate
box. Excel requires you to specify a password to protect and password.
unprotect the worksheet. Use a password that you can
easily remember; after you apply a password to a By default, Excel allows the user to select both locked and
worksheet, no one, including you, can alter the worksheet unlocked cells. When users select a protected cell, they can
without specifying the appropriate password. After you view the contents of the cell in the Formula bar. If you have
unprotect a worksheet, it remains that way until you protect created formulas that you do not want others to view, you
it again. should make sure both of these options are not selected. If
users select an unprotected cell, they can modify the cell in
The Protect Sheet dialog box gives you further control over the Formula bar.
others' actions by allowing you to specify the functions that

PROTECT WORKSHEETS

Select locked cells

⁄ Click Tools ➪ Protection ➪ ■ The Protect Sheet dialog › Select the options you
Protect Sheet. box displays. want to allow the user to
perform while the worksheet
¤ Make sure you select is protected.
the Protect worksheet and
contents of locked cells ˇ Click OK.
option.
‹ Type the password to
protect the worksheet.
24