Get column headings to float when scrolling down?
 

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?

Get column headings to float when scrolling down?
 

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.)

"Wendy" wrote:

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?

Get column headings to float when scrolling down?
 

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

Select cell A4
Goto the menu WindowFreeze Panes

--
Biff
Microsoft Excel MVP


"Wendy" wrote in message
...
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?

Get column headings to float when scrolling down?
 

Select A4 and WindowFreeze Panes.

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


Gord Dibben MS Excel MVP


On Fri, 28 May 2010 07:13:01 -0700, Wendy
wrote:

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?