Get column headings to float when scrolling down?

[Wendy]

How do I get the first three or four lines where I have typed in my column
headings to "float" down as I'm entering information in the lines below?

 

[tim m]

Put your cursor just below the lines you want to float and then 'freeze
panes' (I'm not sure which version of excel you are working with.)

 

[T. Valko]

Let's assume you have column headers in A1, A2 and A3.

Select cell A4
Goto the menu Window>Freeze Panes

 

[Gord Dibben]

Select A4 and Window>Freeze Panes.

Rows 1 to 3 will remain in view as you scroll down the sheet.


Gord Dibben MS Excel MVP