Is it possible to freeze a range in Excel, and at the same time freeze the top row? I've gotten the idea of how to freeze rows and columns at the same time, but this doesn't quite accomplish exactly what I want to do.
Here's the situation:
I have a spreadsheet with information spanning A1:AB99. I want to keep all cells in A1:E20, and all of row 1, always visible while I scroll left/right/up/down through the other data.
If I use Freeze Panes at I2, it will freeze the top row and A:H. However, data in A:H below row 1 will still scroll vertically – this is undesired.
Is there a way to get Excel to do what I'm wanting it to do here?