How to Password-Protect XLS Files

By Leigh Thompson

Microsoft Excel is excellent spreadsheet software for tracking numbers data. Because of the many automatic calculation functions, this software is frequently used to track financial information, employee information and other sensitive information. It is smart computer use to password-protect any file that contains sensitive information. Once the password is set, it must be typed into the software before the XLS file opens. This prevents unauthorized access to the information contained in the file.

Microsoft Excel 2010

Step 1

Open Microsoft Excel 2010.

Step 2

Click "File" on the top menu bar. Choose "Info."

Step 3

Select the option to "Protect Document." Choose "Encrypt with Password" from the list.

Step 4

Enter a password. Click "OK." Retype the password. Click "OK."

Microsoft Excel 2007

Step 1

Open Microsoft Excel 2007.

Step 2

Click the "Microsoft Office" button. Select "Prepare" from the list. Choose "Encrypt" from the menu.

Step 3

Enter a password. Click "OK." Retype the password. Click "OK."

Microsoft Excel 2003

Step 1

Open Microsoft Excel 2003.

Step 2

Click "Tools" on the top menu bar. Choose "Options" and then "Security."

Step 3

Enter a password in the box labeled "Password to Open." Click "OK." Retype the password. Click "OK."