Password protect a workbook

Excel gives you several ways to protect a workbook. You can require a password to open it, a password to change data, and a password for changing the file's structure—adding, deleting, or hiding worksheets.

Remember, though, that this type of protection doesn't encrypt your files. Users can still use third-party tools to read your data.

We'll start with requiring passwords for opening the file and changing data.

  1. Click File > Save As.
  2. Click a location, such as Computer or your My Site web page.
  3. Click a folder, such as Documents or one of the folders on your OneDrive, or click Browse.
  4. In the Save As dialog box, go to the folder you want to use, then open the Tools list and click General Options.

The Tools list in the Save As box

You can enter either of two passwords here, one to open the file, another to change the file.

The General Options dialog box.

See the notes below for more.

 Important    Write your passwords down and store them someplace safe. If you lose them, we honestly can't help you find them.

  1. Enter your password, enter it again to confirm, and click OK.

 Note    To remove a password, follow the steps above and delete the password. Basically, just enter a blank password. You can do that for any type of password that you use in Excel.

To protect the structure of your workbook, do this:

  1. Click Review > Protect Workbook.
  2. Click Structure.

See the notes below for more about this option and the Windows option.

  1. Enter a password in the Password box.

 Important    Write your password down and store it someplace safe. If you lose it, we really can't help you find it.

  1. Click OK, and retype the password to confirm it.

Why did my password disappear when I saved to the Excel 97-2003 format?

You want to send your password-protected Excel 2013 workbook to others, but they're still using Excel 2003, which saves in the Excel 97-2003 (*.xls) file format. You did a "Save As" using the 97-2003 format, but now you've found that the password you set on the workbook has disappeared.

This happens because Excel 2013 uses a new scheme for saving passwords, and the earlier file format doesn't recognize it. As a result, the password is discarded when you save your Excel 2013 file to the Excel 97-2003 format. Set the password in the *.xls file to protect the workbook again.

More about protection and passwords

 
 
Applies to:
Excel 2013