Use the password to open the spreadsheet. Click the Microsoft Office Button, point to Prepare, and then click Encrypt Document. In the Encrypt Document dialog box, in the Password box, delete the encrypted password, and then click OK.
Open Excel and open the workbook for which you wish to remove the password protection. At this point, if you are using Excel 2003 or an earlier version, proceed to Step 2. If you are using Excel 2007, skip straight to Step 5. Click on the File menu, and then select Save As.. One feature that is particularly useful is the password protection offered by the program. Users can protect specified areas of a spreadsheet, or an entire workbook from any unauthorized or accidental changes. Of course, it is important to know how to remove the password protection so that the file can be edited. Remove Excel Workbook/Worksheet Passwords. Excel Password Remover 2007 is a freeware program that you can use to remove/crack/break/unlock a password on an Excel workbook or sheet. However, you still have to be able to open the file itself. If this is your case, download the add-in and double-click on it. Excel will open and you’ll be asked whether to enable or disable the macros associated with the add-in. Of course, enable it. Then go ahead and open the Excel workbook that has the password on it that you would like to get rid of. To assign a password to an Excel workbook, do the following: 1  From the File menu, choose Save As. 2  In Excel 2007, click the Office button and choose Save As. 3  In 2010, click the File tab and choose Save As. 4  Click the Tools dropdown on the dialog toolbar and choose Save Options. 1 From the File menu, choose Save As. 2  In Excel 2007, click the Office button and choose Save As. 3  In 2010, click the File tab and choose Save As. 4  Click the Tools dropdown on the dialog toolbar and choose Save Options. 5  In Excel 2007 and 2010, click the Tools dropdown (in the bottom left corner of the dialog box). 1. Open the workbook and enter the password to open the file. 2. Click the FILE tab and select INFO. 3. Click the dropdown arrow in the PROTECT WORKBOOK box. 4. Click the ENCRYPT WITH PASSWORD option. 5. A box will pop up with the password shown by dots (........). Clear the password dots. Excel 2013 is a bit different, but I figured it out):  Remove password protection from an Excel spreadsheet. Use the password to open the spreadsheet. Click the Microsoft Office Button, point to Prepare, and then click Encrypt Document. In the Encrypt Document dialog box, in the Password box, delete the encrypted password, and then click OK. Set a password in an Excel spreadsheet. To encrypt your workbook and set a password to open it: Click the Microsoft Office Button, point to Prepare, and then click Encrypt Document. In the Password box, type a password, and then click OK. You can type up to 255 characters Double-click on the asterisk that is in the Password to open box, and then press DELETE on your keyboard. DO the same for the box labeled Password to modify.. Click on OK, then Save, and finally Yes to complete the password protection removal if your are using Excel 2003 or earlier. Click on the Review tab at the top of the Excel 2007 window, and locate the group of icons within the Changes group. One feature that is particularly useful is the password protection offered by the program. Users can protect specified areas of a spreadsheet, or an entire workbook from any unauthorized or accidental changes. Of course, it is important to know how to remove the password protection so that the file can be edited. Remove password protection from a Word document. Use the password to open the document. Click the Microsoft Office Button, point to Prepare, and then click Encrypt Document. In the Encrypt Document dialog box, in the Password box, delete the encrypted password, and then click OK. Save the file. Set a password in an Excel spreadsheet. To encrypt your workbook and set a password to open it: Click the Microsoft Office Button, point to Prepare, and then click Encrypt Document. In the Password box, type a password, and then click OK. You can type up to 255 characters Note that you can also open the workbook first and then double-click on the add-on to get the new menu options. I created a test workbook and protected both the sheet and the workbook with a simple password at first. The program worked perfectly and it removed the protection very quickly! If this is your case, download the add-in and double-click on it. Excel will open and you’ll be asked whether to enable or disable the macros associated with the add-in. Of course, enable it. Then go ahead and open the Excel workbook that has the password on it that you would like to get rid of.
http://www.ehow.com/how_5998971_remove-password-protection-excel.html http://www.online-tech-tips.com/ms-office-tips/how-to-remove-crack-or-break-a-forgotten-excel-xls-password/ http://www.techrepublic.com/blog/microsoft-office/use-a-password-to-secure-access-to-an-excel-workbook/ http://answers.microsoft.com/en-us/office/forum/office_2013_release-excel/remove-password-from-excel-2013/66a5b8f8-7d5d-4da0-ad33-d961f364fe55 https://support.office.com/en-us/article/Password-protect-documents-workbooks-and-presentations-EF163677-3195-40BA-885A-D50FA2BB6B68 http://www.ehow.com/how_5998971_remove-password-protection-excel.html https://support.office.com/en-us/article/Password-protect-documents-workbooks-and-presentations-EF163677-3195-40BA-885A-D50FA2BB6B68 http://www.online-tech-tips.com/ms-office-tips/how-to-remove-crack-or-break-a-forgotten-excel-xls-password/
how to remove password protection from excel