Freezing multiple panes on 1 sheet

M

merritts

Hi,

I am hoping to make both the column and row headers scroll with the
user but i can only freeze one or the other. Any suggestions?

Thanks
 
G

Gord Dibben

You can freeze both at the same time.

Select cell B2 and Window>Freeze Panes.

Row 1 and Column A will be become frozen.

The rule is...........columns left of and rows above the selected cell will be
frozen.


Gord Dibben MS Excel MVP
 
Top