How to Unprotect a Spreadsheet in Office 2007. Microsoft Office 2007 has several programs that facilitate the day-to-day operations of small businesses, including PowerPoint, Word and Excel ...

To remove protection from the spreadsheet, open it in Excel, click the "Review" tab and then click "Unprotect Sheet" in the Changes group. Type the password into the Password field and click "OK." ...

For an individual spreadsheet, select Protect Sheet followed by Unprotect Sheet to remove password protections. For a workbook composed of multiple spreadsheets, select Protect Workbook followed ...

The plug-in adds Unprotect workbook and Unprotect sheet options to Excel's Tools menu, and using it is as simple as selecting an option when you're locked out.