Page 454 - Excel 2013 All-in-One For Dummies

436 Password-Protecting the File
OK in this alert dialog box, Excel returns you to the original General Options dialog box, where you can do one of two things:
• Reenter the password in the original text box.
• Click the OK button to redisplay the Confirm Password dialog box, where you can try again to reproduce the original. (Make sure that you’ve not engaged the Caps Lock key by accident.)
If you assigned both a password to open the workbook and one to modify it, Excel displays a second Confirm Password dialog box as soon as you click OK in the first one and successfully reproduce the password to open the file. You then repeat Step 5, this time exactly reproducing the password to modify the workbook before you click OK.
When you finish confirming the original password(s), you are ready to save the workbook in the Save As dialog box.
6. (Optional) If you want to save the password-protected version under a new filename or in a different folder, edit the name in the File Name text box and then select the new folder from the Save In drop-down list.
7. Click the Save button to save the workbook with the password to open and/or password to modify.
As soon as you do this, Excel saves the file if this is the first time you’ve saved it. If not, the program displays an alert dialog box indicating that the file you’re saving already exists and asking you whether you want to replace the existing file.
8. Click the Yes button if the alert dialog box that asks whether you want to replace the existing file appears.
Select the Read-Only Recommended check box in the General Options dialog box instead of assigning a password for editing the workbook in the Password to Modify text box when you never want the user to be able to make and save changes in the same workbook file. When Excel marks a file as read-only, the user must save any modifications in a different file using the Save As command. (See “Entering a password to make editing changes” later in this chapter for more on working with a read-only workbook file.)
Assigning a password to open from the Info screen
Instead of assigning the password to open your workbook at the time you save changes to it, you can do this as well from Excel 2013’s Info screen in the Backstage view by following these simple steps:
1. Choose File➪Info or press Alt+FI. Excel opens the Info screen.
2. Click the Protect Workbook button to open its drop-down menu and then choose Encrypt with Password.