Excel Workbook For Dummies, 2nd Edition

Chapter 18

Protecting Workbooks and Worksheet Data

IN THIS CHAPTER

Assigning a password to open a workbook

Assigning a password to make editing changes in a workbook

Protecting a worksheet and determining which actions are enabled

Protecting the entire workbook

Doing data entry in the unlocked cells of a protected worksheet

Excel enables you to secure your work on two levels:

• Use a password to protect the workbook file so that only the people you trust with the password can open the file to view, print, or edit the data.
• Use a password to protect the worksheets in a workbook from unwarranted changes so that only people with that password can modify the contents and design of the worksheet.

In this chapter, you practice securing your Excel workbooks and worksheets on both these levels. You also get to practice doing data entry in a protected worksheet where all your movements and edits are restricted to the unlocked cells where such changes are allowed.

Password-Protecting the Workbook ...