If you have multiple workbooks in Excel that you need to password protect, using a single password for all of them can save you time and hassle. Here's how to do it:
- Open the first workbook that you want to password protect.
- Click the "File" tab, then click "Save As."
- In the "Save As" dialog box, click the "Tools" drop-down menu and select "General Options."
- In the "General Options" dialog box, enter the password in the "Password to open" field and click "OK."
- Re-enter the password in the "Confirm Password" field and click "OK."
- Click "Save."
- Repeat steps 1-7 for each additional workbook that you want to password protect.