Prev: Averaging a column that contains text
Next: Linking to external files
From: Wendy on 28 May 2010 10:13
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?
From: tim m on 28 May 2010 10:25
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?
From: T. Valko on 28 May 2010 10:29
Let's assume you have column headers in A1, A2 and A3.

Select cell A4
Goto the menu Window>Freeze Panes

--
Biff
Microsoft Excel MVP


"Wendy" <Wendy(a)discussions.microsoft.com> wrote in message
news:909301CE-ADFA-4AF7-AE5B-8CCEE68A26A9(a)microsoft.com...
> 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?


From: Gord Dibben on 28 May 2010 10:32
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


On Fri, 28 May 2010 07:13:01 -0700, Wendy <Wendy(a)discussions.microsoft.com>
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?

 | 
Pages: 1
Prev: Averaging a column that contains text
Next: Linking to external files