how to make the excel file password protected

Then next time you open the Excel file, it will prompt you for the password to open the Excel file and see its contents.Ģ) Save file with a password using Save As command. Then save the Excel file (this will save the password to open encryption that you added).

In the next window that opens up, confirm the password and then click OK. In the window that opens up, enter a password and then click OK.

In Excel 2010, Excel 2013, and Excel 2016, to encrypt and password protect an Excel file, click the File tab in the Excel Ribbon, then click Info, then click Protect Workbook, then click Encrypt with Password.

Then next time you open the Excel file, it will prompt you for the password to open the Excel file and see its contents.

In Excel 2007, to encrypt and password protect an Excel file, click the round Office Button in the top left corner of Excel and then click Prepare and then click Encrypt Document.

There are two ways to password protect and encrypt an Excel file.ġ) Encrypt an Excel file (This locks the Excel file with a password) However, you have the option of creating your own password protected Excel file if you want.

The Excel templates that are available on, including the Excel checkbook registers, budget spreadsheets, and Excel calendars, do not require a password to open the Excel file. You can protect an Excel file by requiring a password to be entered when opening the Excel file. After encrypting an Excel file, the Excel file requires a password to open it and view its contents. Applies to all Excel templates including: ' Georges Budget for Excel', ' Georges Excel Checkbook Register', ' Georges Excel Checkbook for Mac'Įncrypting an Excel file locks the Excel file with a password.

How to make the excel file password protected