How to Add a Password on an Excel Document

Save

Excel documents are often used to record financial and other sensitive information. Excel offers two different ways to password protect your documents. You can add an encrypted password to keep unauthorized individuals from accessing the document. You can also protect worksheets or a whole workbook to prevent unauthorized people from making changes to the document.

Encrypted Password for the Document

  • Open or create your Excel Document and click the "File" tab in the top menu to open the "Backstage view" pane on the left side of the Excel document.

  • Click "Info" in the "Backstage view" pane to open the "Permissions" page.

  • Click the "Protect Workbook" icon and select "Encrypt with Password" from the pull-down list to open the "Encrypt Document" dialog box.

  • Enter your password in the textbox. Select the "OK" button to save the password and return to the Excel Document.

Password Protect a Worksheet or Workbook

  • Open or create your Excel Document and click the "Review" tab in the top menu.

  • Select any cells you want to be exceptions to the protection rules. To remove cell protection, click the "Home" tab and click the square arrow in the bottom-right corner of the "Font" section to open the "Format Cells" dialog box. Click the "Protection" tab. Uncheck the "Locked" checkbox. Click "OK" to save the changes and return to the document.

  • Skip this step if you only want to protect a workbook. Click the "Protect Sheet" icon in the "Changes" section to open the "Protect Sheet" dialog box to protect a worksheet. Click any options available according to your preferences. Enter the password in the textbox. Confirm the password and click the "OK" button to return to the worksheet. To remove worksheet protection, click the "Review" tab, then the "Unprotect Sheet" icon. Enter your password in the "Unprotect Sheet" dialog box and click the "OK" button.

  • Skip this step if you only want to protect a worksheet. Click the "Protect Workbook" icon to open the "Protect Structure and Windows" dialog box. Check your preferences and enter a password in the text box. Confirm the password and click the "OK" button to return to the workbook. If you check the "Protect Structure" box, users cannot add, remove, copy or change the names of worksheets. If you check the "Windows" box, users cannot resize windows. To remove workbook protection, click the "Review" tab in the top menu, click the "Protect Workbook" icon and select "Protect Structure and Windows." The "Unprotect Workbook" dialog box will appear. Enter the password and click the "OK" button.

Tips & Warnings

  • Record your passwords somewhere safe because there is no way to recover your passwords through Excel if you forget them.

References

  • Photo Credit Jupiterimages/Brand X Pictures/Getty Images
Promoted By Zergnet

Comments

Resources

You May Also Like

  • How to Set a Password on Excel 2007

    Passwords are useful to prove identity and authenticate yourself when dealing with computer files. To encrypt and protect your Microsoft Excel 2007...

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!