Re-enter both passwords in the text box provided to make sure they match. Once you've entered both passwords, click the 'OK' button. You may choose to use the same password to open and edit the file to make it easier to remember.

In the same pop-up window, type the password you plan to use to edit the file. In the pop-up window that appears, type the password you plan to use to open the file in the future. In the upper left corner of your screen, select the 'File' tab by clicking on it in your toolbar.Ĭlick on the 'Passwords' button on the drop-down menu.

You can follow these instructions to add an Excel password if you're using a Mac device: Related: How To Search in Excel in 5 Steps (Plus Tips) 2. Re-enter the same password and click 'OK' again to set your password. Type your password in the text box and click the 'OK' button.

On the info page, select the box labeled 'Protect Workbook.'Ĭlick on the 'Encrypt with Password' button in the drop-down menu. Select the 'Info' button from the drop-down menu. In the upper left corner of your screen, click on the 'File' tab on your toolbar. Open the spreadsheet you want to create a password for in Excel. You can follow these instructions to add an Excel password if you're using a PC device: Here are some instructions you can use to create an Excel password on a PC or a Mac device: 1. If you want to add an extra layer of security to your Excel spreadsheets, you may choose to add a password. Related: How To Delete Comments In Excel (Plus Simple Tips) How to add an Excel password This allows you to share information with your colleagues while ensuring they can't make any changes to the data unless they know the password. To do this, you can require users to insert a password if they wish to edit the spreadsheet. Another reason you may choose to set a password for an Excel spreadsheet is if you want to share it with other individuals as a read-only document. If you're working on sensitive information, such as a financial report for your business, this can help you ensure it stays protected. Why have a password for Excel?Ĭreating a password for your Excel spreadsheets can prevent unauthorized individuals from accessing your work. In this article, we explain why you may choose to have a password in Excel and provide steps to help you add, remove or change your password on a PC or Mac device. If you're creating spreadsheets in Excel, you might benefit from learning about how to remove a password from a file. This program gives users the option to protect their work by adding a password to keep it more secure. Excel is a popular software program that many companies use to create spreadsheets and compile data.

How to put password for excel file