I have a client who asked me if I could help him figure something out based on some sales reports. I said I'd look into it, but I'm not really much of an Excel user. Normally, I can figure this stuff ...

You can freeze a row in Excel through the "Freeze Panes" menu. This lets you scroll through a spreadsheet without that frozen data leaving the screen.