Page 242 - Excel Workbook for Dummies

24_798452 ch17.qxp 3/13/06 7:39 PM Page 225
Chapter 17: Protecting the Spreadsheet 225
Format Columns to enable formatting so that users can modify the column
widths and hide and unhide columns.
Format Rows to enable formatting so that users can modify the row heights and
hide and unhide rows.
Insert Columns to enable the insertion of new columns in the worksheet.

Insert Rows to enable the insertion of new rows in the worksheet.
Insert Hyperlinks to enable the insertion of new hyperlinks to other documents,
both local and on the Web (see Chapter 21).
Delete Columns to enable the deletion of columns in the worksheet.
Delete Rows to enable the deletion of rows in the worksheet.
Sort to enable the sorting of data in unlocked cells in the worksheet (see
Chapter 16).
Use AutoFilter to enable the filtering of data in the worksheet (see Chapter 16).

Use Pivot Table Reports to enable the manipulation of pivot tables in the work-
sheet (see Chapter 19).
Edit Objects to enable the editing of graphic objects such as text boxes, embed-
ded images, and the like, in the worksheet (see Chapter 15).

Edit Scenarios to enable the editing of what-if scenarios, including modifying and
deleting them (see Chapter 18).

Try It

Exercise 17-2: Protecting a Worksheet
Open Exercise17-2.xls in your Chapter 17 folder in the My Practice Spreadsheets folder
on your hard disk or in the Excel Workbook folder on the workbook CD-ROM. This
workbook contains a copy of the Depreciation worksheet that you worked with in
Chapter 8. You will use the Depreciation Table on this worksheet to practice unlocking
cells before turning on protection in the worksheet:
1. Select the cell range C3:C6 in the Depreciation worksheet and then open the
Format Cells dialog box (Ctrl+1), click the Protection tab, and deselect the
Locked check box before you select OK.
These four cells constitute the input cells for the Depreciation Table where you
need to still be able to enter new values even after turning on worksheet protec-
tion. By leaving the protection status of the other cells set to locked in the
spreadsheet, you ensure that no one can make any changes to the formulas in
the table itself, either intentional or otherwise.
2. Choose Tools➪Protection➪Protect Sheet to open the Protect Sheet dialog box.
When the Protect Sheet dialog box first opens, only the Protect Worksheet and
Contents of Locked Cells check box located above the Password to Unprotect
Sheet text box and the Select Locked Cells and Select Unlocked Cells in the Allow
Users of This Worksheet To list box located below it are selected.
3. Type stet (the Latin command meaning “Let it stand”) in all lowercase letters in
the Password to Unprotect Sheet text box and then select OK without bothering
to deselect any of the three check boxes that are automatically selected.
4. Retype stet in the Reenter Password to Proceed text box in the Confirm
Password dialog box before selecting OK.