Excel's Custom Views tool lets you create a snapshot of your spreadsheet, allowing you to toggle between layouts.
The Freeze feature in Excel allows you to scroll down through hundreds of rows and still see the original headers or field names in row 1, or scroll over hundreds of columns and still see the data ...