Part IV: Managing and Analyzing Data
- Dismiss the remaining dialog boxes by clicking OK.
- Protect the sheet. You can click the Protect Sheet button on the Allow Users to
Edit Ranges dialog before you dismiss it or use the Protect Sheet command on the
Review Ribbon.
Protecting a Workbook
Excel provides two ways to protect a workbook:■ Require a password to open the workbook■ (^) Prevent users from inserting sheets, deleting sheets, hiding sheets, and unhiding
sheets
These are not mutually exclusive, so both methods can be applied to a workbook. We dis-
cuss each of these methods in the sections that follow.
Requiring a password to open a workbook
Excel lets you save a workbook with a password. After you do so, whoever tries to open the
workbook must enter the password.
To add a password to a workbook, follow these steps:
- Choose File ➪ Info ➪ Protect Workbook ➪ Encrypt with Password. The Encrypt
Document dialog box, shown in Figure 34.5, appears.
FIGURE 34.5
Specify a workbook password in the Encrypt Document dialog box.- Type a password and click OK.
- Type the password again and click OK.
- Save the workbook.