Excel Question

[Caveman]

I've got Column AND Row headers that I want to remain "in view" as I scroll up/down and across the data fields.

I know how to freeze the top row (Column Header) so it stays in view if I scroll down, but how do I keep the left side (Row header) in view while I scroll left/right while SIMULTANEOUSLY maintaining the up/down "keep in view" capability.

I'm pretty sure I'v been able to do this once before, but forgot how to do it...

 

[mayest]

The key is the cell that you have selected when you do the Freeze Panes. If you have B2 as the active cell, then Freeze Panes will freeze row 1 and also column A. Everything above and to the left of the active cell will be "frozen."

 

[Caveman]

THANKS!!!

I was frezing with rows or columns of cells instead of just 1 individual cell.