Freezing panes in Excel
I made peace with a monster spreadsheet recently with this tip to freeze the header row and column at the same time to keep them both visible while scrolling.
Place the cursor in a cell below and to the right of the row and column you want to freeze, then select View > Freeze Panes > Freeze Panes.
The header row and column stay frozen on screen alongside those far out cells after scrolling.
Thanks to Kerri for teaching me this tip just when I needed it!