Page 243 - Excel Workbook for Dummies

24_798452 ch17.qxp 3/13/06 7:39 PM Page 226
226 Part IV: Managing and Securing Data

5. Make the following changes to the designated cells in the Depreciation worksheet:
• 35000 in the Cost cell, C4
• 7 in the Life_in_years cell, C5
• 5000 in the Salvage cell, C6
Excel enables you to make these changes because you assigned the unlocked
protection formatting to these cells before turning on worksheet protection.
Because the worksheet still uses the default automatic recalculation setting, the
program recalculates the depreciation values in the Depreciation Table (C9:F19)
each time you update an input value.
6. Position the cell cursor in cell D17 containing the first of the #NUM! error values
in the table and then press F2 to put Excel in Edit mode.
Excel beeps at you and displays a warning dialog box indicating that the cell or
chart you’re trying to change is protected.
7. Position the cell cursor in the merged cell B2 and then press the Delete key to
remove its contents.
Again, Excel beeps at you and displays the warning dialog box indicating that the
cell or chart you’re trying to change is protected.

8. Open the Insert and Format pull-down menus and notice how many of the com-
mands are grayed out, indicating that they are currently unavailable.
9. Choose Excel’s Tools➪Protection➪Unprotect Sheet menu command.
Excel displays the Unprotect Sheet dialog box where you need to enter the
password.
10. Type stet in the Password text box of the Unprotect Sheet dialog box and then
select OK.
11. Reopen the Protect Sheet dialog box (Tools➪Protection➪Protect Sheet) and then
select the Format Cells check box (in addition to the Select Locked Cells and
Select Unlocked Cells check boxes) before selecting OK (don’t bother to assign a
password to unprotect this time).
By selecting the Format Cells check box in the Allow Users of This Worksheet To
list box before turning on the worksheet protection another time, you enable for-
matting changes to locked cells in the worksheet, while at the same time denying
the ability to make changes to their contents or delete them.
12. While the cell cursor is still located in cell B2, click the Italic button on the
Standard toolbar to format the Depreciation Table heading in this cell with
italics.
13. Click the I-beam mouse pointer on the Formula bar to attempt to edit this head-
ing in cell B2.
This time, Excel reverts back to beeping at you and displaying the warning dialog
box indicating that the cell or chart you’re trying to change is protected.
14. Press the Delete key to attempt to remove the heading from cell B2.
Again, Excel refuses to follow your command, instead beeping at you and dis-
playing the same old tired warning dialog box indicating that the cell or chart
you’re trying to change is protected.
15. Position the cell cursor in cell A1 and then save the protected version of the
Depreciation worksheet in a new file named Solved17-2.xls in your Chapter 17
folder in the My Practice Spreadsheets folder. Close the workbook.