Save the Excel file and it will be protected with open password.Ģ. Type a password in Password to open input box.

Go to File Save As, and in Save As dialog, choose Tools General Options at the right-bottom side. Way 2: Set open password in 'Save As' dialog Way 1: Use option 'Protect Workbook Encrypt with Password'įor example, in Microsoft Excel 2010/2013/2016, go to File Info Protect Workbook Encrypt with Password, then type the password to encrypt the Excel file, and reenter it to confirm.Ībout details, please refer to how to add open password to encrypt Excel 2016 file How to protect excel file/workbook/sheets/worksheets with open password? It is the simplest password you can use to protect your excel file/workbook/sheets from opening and viewing by others. Open password | protect Excel file/sheet from opening/viewing Edit password - protect excel workbook/sheet from changesġ.

Open password - protect excel file from viewing Option 1: Password Protect Excel Workbook/Sheet on Microsoft Excelįirst, see the two common passwords the Microsoft Excel provides to protect excel file and excel sheet/workbook/worksheet.

Option 5: Password protect excel file via BitLocker Drive Encryption.

Option 4: Password protect excel file by ZIP/7ZIP/WinZip.

Option 3: Password protect Excel file by WinRAR/RAR.

Option 2: Password protect Excel file with iSunshare SafeFile Genius.

Option 1: Password protect Excel Workbook/Spreadsheet/Worksheet on Microsoft Excel.

Please go on and password protect your excel file for high security.ĥ options to protect Excel file and Excel Sheet/Workbook/Spreadsheet/Worksheet with password:

Here I would like to show you more effective utilities, rar/zip/bitlocker etc to protect your important Excel file better with powerful password. On only Microsoft Excel 97-2016? Surely not. But we just could password protect Excel file In order to password protect the data saved in excel file, what can be sure is that we can set open password to protect excel file/workbook from viewing, or edit password to protect excel worksheet/sheet/spreadsheet, and workbook structure/windows from modifying. While we right click on desktop and choose to create a Microsoft Excel Worksheet, 3 sheets will be created automatically in this excel file. Password Protect Excel File and Excel Sheet/Workbook/Spreadsheet/WorksheetĪs is known, an excel file is a file saved like this, xxx.xls or xxx.xlsx, also called workbook, which probably includes one or several excel worksheets/sheets.

How to put password on excel file