Excel – Freeze top row, plus a range, in Excel


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?

Best Answer

I'm afraid that there is no way I can think of that will do this. Freezing stuff is about fixing full rows and/or columns.

The only thing I can think of would involve some pretty horrible programming where you would need to create your own pseudo scrolling.

It would probably be easier to do in a web page rather than Excel. Though that would still need significant JavaScript programming.