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." ...

At any stage, should you feel to unprotect the sheet and show the formulas again, select Unprotect sheet option and enter the saved password in Unprotect Sheet password box.