If you don't have access to the password, you can click on the "Preview" option to open the password-protected MS Office file ...
Excel's Custom Views tool lets you create a snapshot of your spreadsheet, allowing you to toggle between layouts.