Excel 2010 Bible

Part IV: Using Advanced Excel Features

642

To add a password to a workbook, follow these steps:

1. Choose File ➪ Info ➪ Protect Workbook ➪ Encrypt With Password. Excel displays
   the Encrypt Document dialog box shown in Figure 31.5.


2. Type a password and click OK.


3. Type the password again and click OK.


4. Save the workbook.

FIGURE 31.5

Specify a workbook password in the Encrypt Document dialog box.

Note
You need to perform these steps only one time. You don’t need to specify the password every time you resave
the workbook. n

To remove a password from a workbook, repeat the same procedure. In Step 2, however, delete

the existing password symbols from the Encrypt Document dialog box, click OK, and save your

workbook.

Figure 31.6 shows the Password dialog box that appears when you try to open a file saved with a

password.

FIGURE 31.6

Opening this workbook requires a password.