Page 245 - Excel Workbook for Dummies

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

5. Position the cell cursor in cell C4 and then make the following data entries
across the rows of the unlocked cell range in the designated cells by pressing
Tab to complete each entry and, at the same time, move the cell cursor to the
next cell in the same or next row:
• 36-inch round table in cell C4
• 1250 in cell D4
• 72-inch dining table in cell C5
• 1400 in cell D5

• Hutch in cell C6
• 2500 in cell D6
6. While the cell cursor is positioned in cell C7, make the following data entries
down the columns of the unlocked cell range in the designated cells by pressing
the Enter key to complete each entry and, at the same time, move the cell cursor
to the next cell in the same or next column:
• Side chair in cell C7
• Arm Chair in cell C8
• Armoire in cell C9
• 350 in cell D7 (press Enter three times to position the cell cursor here)
• 500 in cell D8
• 1750 in cell D9
7. Save the protected worksheet version with the completed Spring Sale Furniture
Prices table in a new workbook named Solved17-3.xls in your in your Chapter 17
folder in the My Practice Spreadsheets folder and then close the workbook.

Protecting the Entire Workbook

You can apply one last level of protection to your spreadsheet files and that is to pro-
tect the entire workbook. When you protect the workbook, you ensure that its users
can’t change the structure of the file by adding, deleting, or even moving and renaming
any of its worksheets.
To protect your workbook, you open the Protect Workbook dialog box (Tools➪
Protection➪Protect Workbook). The Protect Workbook dialog box contains two
check boxes: Structure (which is automatically checked) and Windows (which is
not selected). This dialog box also contains a Password (Optional) text box, where you
can enter a password that must be supplied before you can unprotect the workbook.

When you protect a workbook with the Structure check box selected, Excel prevents
you or your users from doing any of the following tasks to the file:

Insert new worksheets
Delete existing worksheets
Rename worksheets
Hide or view hidden worksheets
Move or copy worksheets to another workbook