How to Override an Excel Password

1. Make a new spreadsheet. Leave it entirely blank. If it is a protected workbook, instead of just one sheet, make a new workbook.
2. Click on the top left corner of the protected spreadsheet's header bars (above the 1, left of the A) to highlight the whole sheet.
3. Copy the spreadsheet, either by pushing 'Ctrl' 'C' or by selecting 'Edit' from the menu bar and clicking on 'Copy.'
4. Click on your new blank spreadsheet. Click the top left corner to highlight the whole sheet, as in Step 2.
5. Paste the copied spreadsheet by pushing 'Ctrl' 'V' or by selecting 'Edit' from the menu bar and clicking on 'Paste.' You now have an identical copy of the protected spreadsheet---only it's not protected.
6. Rename the new spreadsheet to match the name of the old one (you may have to first rename or delete the old one to do this, if they are in the same workbook).
7. Manually copy all of the page setup settings, if you need to print this spreadsheet just like the old one. With the old, protected spreadsheet pulled up, select 'File' from the menu bar and click on 'Page Setup.' Go through the tabs and write down all the settings. Return to the new spreadsheet. Open the page setup box and enter the settings.
8. Repeat Steps 1 through 7 for each spreadsheet, if it is a whole workbook being copied. Rename the new workbook to match the old one when you are finished.