Excel's Custom Views tool lets you create a snapshot of your spreadsheet, allowing you to toggle between layouts.
If Word, Excel, PowerPoint automatically reset settings on exit, follow these instructions e.g. check folder and Reigtsry ...