Excel 2019 Bible

Chapter 34: Protecting Your Work

34

You need to perform these steps only once. You don’t need to specify the password every time you save the

workbook.

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 34.6 shows the Password dialog box that appears when you try to open a file saved

with a password.

FIGURE 34.6

Opening this workbook requires a password.

Excel provides another way to add a password to a document:

1. Choose File ➪ Save As and click Browse. The Save As dialog box appears.


2. Click the Tools drop-down and choose General Options. The General Options dia-
   log box appears.


3. Enter a password in the Password to Open field.


4. Click OK. You’re asked to reenter the password before you return to the Save As
   dialog box.


5. In the Save As dialog box, make sure that the filename, location, and type are
   correct; then click Save.

The General Options dialog box has another password field: Password to Modify. If you specify a password for this

field, the file opens in read-only mode (it can’t be saved under the same name) unless the user knows the password.

If you use the Read-Only Recommended check box without a password, Excel suggests that the file be opened in

read-only mode, but the user can override this suggestion.