Last time we have talked about setting a password to protect your Excel 2010. If you want more details, the article how to password protect excel 2010 is recommended for you. However, not every Excel worksheet or workbook needs the password cause you need to public the Excel file to your workmates or others. Today let`s talk about how to unprotect excel 2013/2007 without a password. Keep reading, below are the steps to unprotect Excel 2007/2013 workbooks or worksheets.
Method1. Unprotect excel 2007/2013 password when you know the password
Just follow the below easy steps to remove password of a workbook in excel 2007/2010/2013, then you can unprotect excel without password.
Open Microsoft Excel workbook that you want to get rid of the password protection.
Click the office button on the top left corner.
Tap "Save As" option.
In the "Save as" dialog box, click "Tools" button and choose "General Options" in the drop-down options.
In the "Password to open" box, delete the existing password and click OK button. If you do not want to rename the file, click "Yes" to replace the existing workbook.
Method2. Unprotect excel 2007/2013 password when you forgot the password
Fortunately, if you forgot the excel password, there is third-party password remover tool for Excel/Word/PowerPoint, such as the Workbook unprotect Genius. This is one of the best comprehensive Office password recovery software which is helpful to recover password for Windows, Office documents, Outlook, RAR/WinRAR, ZIP, PDF, and more. Now you can follow the steps below to unprotect excel 2007/2013 by this Workbook unprotect Genius.
Step 1: Use Workbook Unprotect Genius to install and run on your PC.
Step 2: Navigate the excel file that includes the worksheet you need to unprotect.
The excel file you choose should be saved in *.xlsx format and include the worksheet you want to unprotect. If it is *.xls file, you need to convert it into *.xlsx at first. Then click Open button on iSunshare Workbook Unprotect Genius to browse and select it in your computer, then add it to iSunshare software with "Open" button.
Step 3: Remove sheet password to unprotect Excel worksheet.
Tap on Remove Password button and sheet password, workbook protection password and read-only password would be removed from excel file simultaneously, supposing your excel file is protected with all of these passwords.
Click OK, now you will get an unprotected excel file, which contains your unprotected worksheet. No matter of whether you know the password or not, it is easy to unprotect excel workbooks and worksheets(97-2013).