Afterward, a password-free copy of the parent Excel file will be available in the selected directory.Delete the passwords and then click OK.Then there will be a small window containing the password that will spawn.Select General Options from the drop-down menu. When you click on Tools, a dropdown menu will appear.Then, in the File browsing box that appears, select the location of your file.Then a green left side panel will open, from the panel, click on Save As option.To utilize this method, first, choose the File option from the drop-down menu.You can find an option named Tools from Save As command, which enables us to save the file without any passwords. General Options to Remove Password Protection After then you will see the highlight on the Protect Workbook is now no longer showing.Ģ.Remove that password by pressing Backspace on the keyboard.You will observe that there is a password already in place. After clicking on the Encrypt with Password, a new window will appear.This means this workbook is protected with a password. When the starting window opens, click on the Info option, and from that option, you will notice that there the protect workbook option is grayed out.To do this, first, click on the File option.But at the same time, we also want to remove the password permanently from the Excel file.To remove this password, you need to know the password, in this case, the password is exceldemy.You will notice that the file is now protected and asking for a password.At first, you need to select the Excel file that needs to be unlocked.Although the password has to be known beforehand. This method will remove the passwords from the file directly. How we remove passwords from this worksheet will discuss. We have got here the marks of students in various subjects. We are going to use the below dataset for demonstration purposes. Remove Password From Excel File When Opening.xlsxĤ Easy Ways to Remove Password from Excel File When Opening

How to create password for excel file