how to make excel sheet password protected

Click on the File tab given on the top-left side of the Excel spreadsheet opened in front of you.Open the file for which you want to remove password.

In the menu bar, choose the File tab and select the Save option.Now, delete the passwords for both text fields and press OK. You will see a dialog box File Passwords that shows the password protection to open and edit the excel file.See on the top-left side of the Excel spreadsheet in front of you, click the File tab and choose Passwords from the list.It is time to enter the password and click OK.Go to the Excel file for which you need to remove the password.Click on the File menu and choose the Save option.You have to remove passwords from Excel file for both text fields. In the General Options dialog box, you will see an option that shows encrypted passwords to open and edit the file.

By clicking on the drop-down menu, you will be needing to choose General Options.

Select the Tools option given at the bottom right side of the window.

Choose a folder and you will see a new window open.

On the top-left side of the Excel spreadsheet, simply go to the File tab and choose Save As option.

Go to the encrypted Excel file for which you need to remove the password.

For this, you need to follow the steps given below: Remove Password With the Save As Optionīy using this method, you can also remove passwords from Excel files. “Protect Current Sheet” and “Protect Workbook Structure options,” you can have an Unprotect Sheet window and add the password. This step is typically used for Excel versions 2010 to 2019.įor Excel 2007 and older versions, you may have to follow the step given below:

Clicking on the “Protect Workbook” will open up a drop-down menu from which you have to choose the type of password protection you had to remove.įor Encrypt with Password option, you need to clear the password by clicking OK to remove the password.

Click on the File tab given on the top-left corner of the opened worksheet.

How to make excel sheet password protected