Skip to content

how to remove password from excel

    Excel is a well-known software application that numerous businesses use to make spreadsheets and compile data. It allows users to protect their work by incorporating a password to make it more secure. If you’re making spreadsheets using Excel and Excel, you may be interested in learning how to delete a password from a document.

    We discuss why you might want to use a password on Excel and give instructions to modify, delete or add your password on a PC or a Mac device.

    Remove the Excel username from the Review tab.

    1. Open the password-protected Excel file that you wish to deactivate the password.

    2. enter Excel’s password and click OK. Excel password and then click OK.

    3. In the main menu in the opened Excel spreadsheet, select the Review tab.

    4. Click on the Unprotect Sheet option, then enter the password.

    5. To erase your document password, ensure it is locked for editing, click the option to Protect Sheet, and then click OK without entering the new password.

    6. Click FFileand, then click Save.

    Alternatively, you can deprotect the Sheet and remove any passwords from Home using The Format menu.

    For Mac Users

    Open the Excel file, where you have to delete the password.

    The time has come to enter your password and then click OK.

    Check the top-left corner of the Excel spreadsheet before you click on the File tab and select Passwords from the menu.

    There will be a dialog area, File Passwords, that shows the password protection that allows you to open and edit the Excel file. After that, delete all passwords in both fields and then click OK.

    On the menu bar, select the File tab, and then choose”Save.

    Remove the Password from the Panel

    Follow the steps below:

    Open the file in which you wish to erase the password.

    Enter the password, then click OK.

    Select the File tab located in the upper-left corner of the Excel spreadsheet. It will open before you.

    Then, click Info and then select Protect Workbook given in the left-hand panel. It will display the drop-down menu.

    In the drop-down menu, you must select secure your password with encryption and remove the password within the field of text.

    Once you’ve deleted the old password After that, click OK at the bottom of the screen.

    Select FFilein the menu and click the Save option to save the entire procedure.

    Remove Password to Modify Excel 2010 Worksheet/Workbook

    Password protections such as changing passwords, worksheet passwords, and the structure password for workbooks can block the ability to modify Excel 2010 worksheets or workbooks. When opening the file, how do you remove these security measures for passwords in Excel 2010? To save time in the search and testing process, we suggest an application that will remove the formatting and editing restrictions from Excel 2010 with just one click. Passport for Excel is what we previously mentioned in the earlier section. We suggest this tool because it ensures a 100% removal rate.

    To eliminate all password protections for Excel 2010 workbooks or worksheets, take these easy steps:

    Step 1: Launch Passper on your computer, and then select”Remove Restrictions” mode “Remove Restrictions” mode.

    Step 2: Step 2 “Select a File” to browse for the restricted file and then add it to the software.

    Step 3. Once the files are imported into Passper, Step 3: Once the document is added, click “Remove,” and the program will quickly remove any restrictions from the Excel sheet, making it easier to edit.

    Remove the password from Excel 2007-2016 using VBA Code.

    First, ensure that you can responsibly apply this method and cautiously. Be sure you utilize it to eliminate the password from your personal Excel sheet. The VBA script typically goes through the process of checking passwords.

    Step 1: After opening Excel Worksheet, open Excel Worksheet, go to the Editor by pressing Alt and F11.

    Step 2: Following that, click on Step 2: Afterward, go to the “Insert” option and select “Module.” Now, you have to select the appropriate file from the list. There will be a “Declaration window” to paste the code.

    Step 3: You can run this program (hit”F5.) The program will continue to run until the button is accessible again.

    Step 4: Once you have completed this step, you will be taken back to the excel spreadsheet you wish to deprotect. At this point, you will see an alert box with the code.

    Step 5: Go to the “Review” section and click the “Unprotect Sheet” option. You will be required to enter the generated code for the field to enter your password. That’s it! Excel is now protected.

    Unlock Excel Files Protected by Password Online with no password

    While we’re at it while we are there, it is crucial to be aware that not every file can be unlocked. It won’t be wrong to suggest that online methods for unlocking password-protected Excel files only work when the password isn’t enough. It is also not a 100% secure method to access an Excel file. So, it is recommended to opt for online options only when the Excel file is not containing vital information.

    If you’ve decided to take the online ways to access your Excel password, here are the steps you need to follow to get Excel passwords online and at no cost:

    Open Site: Go to your chosen online portal to complete your task.

    Upload File: When you’ve opened your online screen on your desktop, You will see an option that reads ‘Drop file to upload’ or click here to upload. You can upload the Excel file into another window or click the “click here” option to browse and upload the desired file.

    Relax and relax. The work is almost complete because once you have uploaded the file, the password recovery process will begin and perform its task. The time required to complete the process is contingent on a variety of factors, and one among them is password strength. You can constantly monitor the progress of recovery in the monitor.

    Write down the password. When the recovery process is completed, you’ll be able to see the password that was cracked on your display. It is possible to take a record of the password so that you remember it next time.

    That’s it! Step-by-step instructions to unlock excel password-protected online at no cost.


    It is always advisable to safeguard your Excel files by using the use of a password. However, it could be an issue if you do not remember the password for a necessary file. We have discussed the most effective methods to retrieve and eliminate Excel passwords in such situations.

    If you’ve wrongly deleted or damaged the Excel spreadsheet, it could be challenging to retrieve or fix. Let the EaseUS EaseUS Data Recovery Wizard handle this task to help you skip the complicated steps. It’s an easy procedure to repair and recover all of your Excel files.

    Leave a Reply

    Your email address will not be published. Required fields are marked *

    You cannot copy content of this page