How do I create a "floating" header in Excel so I can always see i

G

Gord Dibben

Andy

To have row 1 always in view as you scroll down.

Select A2 and Window>Freeze Panes.

Rule is: whatever is above and left of the selected cell will be frozen after
you hit Window>Freeze Panes.

i.e. select B2 to have Column A and Row 1 frozen.


Gord Dibben Excel MVP

On Wed, 16 Nov 2005 13:38:00 -0800, Andy Heal <Andy
 
Top