How to Remove Password Protection in Excel

1. 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.
2. Click on the 'File' menu, and then select 'Save As.' Click on the 'Tools' menu and select 'General Options.'
3. 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.'
4. Click on 'OK,' then 'Save,' and finally 'Yes' to complete the password protection removal if your are using Excel 2003 or earlier.
5. Click on the 'Review' tab at the top of the Excel 2007 window, and locate the group of icons within the 'Changes' group. Click on 'Unprotect Sheet.' Type in the appropriate password when and if you are prompted, and you are finished.