I'm not sure what formula to use. I am trying to count in numerical order
down a column, ie 1,2,3,4 and so on. Rather than have to type each individual
number, I would like Excel to fill in the columns for me. I've done it once
before but can't remember the formula. Can someone help with this?

In A1 put 1
In A2 put 2
then highlight both cells and left click on the little black square in the
bottom right hand corner of A2 and hold left mouse button down and drag it
down as far as you want.

Vaya con Dios,
Chuck, CABGx3



"Krickette33" wrote:

I'm not sure what formula to use. I am trying to count in numerical order
down a column, ie 1,2,3,4 and so on. Rather than have to type each individual
number, I would like Excel to fill in the columns for me. I've done it once
before but can't remember the formula. Can someone help with this?

jinx!

"CLR" wrote:

In A1 put 1
In A2 put 2
then highlight both cells and left click on the little black square in the
bottom right hand corner of A2 and hold left mouse button down and drag it
down as far as you want.

Vaya con Dios,
Chuck, CABGx3



"Krickette33" wrote:

I'm not sure what formula to use. I am trying to count in numerical order
down a column, ie 1,2,3,4 and so on. Rather than have to type each individual
number, I would like Excel to fill in the columns for me. I've done it once
before but can't remember the formula. Can someone help with this?

LOL.........haven't heard that in YEARS.............

Vaya con Dios,
Chuck, CABGx3


"dlw" wrote in message
...
jinx!

"CLR" wrote:

In A1 put 1
In A2 put 2
then highlight both cells and left click on the little black square in
the
bottom right hand corner of A2 and hold left mouse button down and drag
it
down as far as you want.

Vaya con Dios,
Chuck, CABGx3



"Krickette33" wrote:

I'm not sure what formula to use. I am trying to count in numerical
order
down a column, ie 1,2,3,4 and so on. Rather than have to type each
individual
number, I would like Excel to fill in the columns for me. I've done it
once
before but can't remember the formula. Can someone help with this?

Or forget entering the 2

Just enter 1 in A1.

Right-click on the fill handle and drag down.

Release button and "Fill Series"


Gord Dibben MS Excel MVP

On Tue, 5 Feb 2008 12:28:10 -0800, CLR wrote:

In A1 put 1
In A2 put 2
then highlight both cells and left click on the little black square in the
bottom right hand corner of A2 and hold left mouse button down and drag it
down as far as you want.

Vaya con Dios,
Chuck, CABGx3



"Krickette33" wrote:

I'm not sure what formula to use. I am trying to count in numerical order
down a column, ie 1,2,3,4 and so on. Rather than have to type each individual
number, I would like Excel to fill in the columns for me. I've done it once
before but can't remember the formula. Can someone help with this?

type the 1, and the 2 below it, then highlight them both, then click and hold
the "fill handle" that's the black square in the lower right hand corner of
the cell with the 2 in it, and drag it down

"Krickette33" wrote:

I'm not sure what formula to use. I am trying to count in numerical order
down a column, ie 1,2,3,4 and so on. Rather than have to type each individual
number, I would like Excel to fill in the columns for me. I've done it once
before but can't remember the formula. Can someone help with this?

hi
in A2, enter the number 1.
in A3, enter =A2+1.
copy down.

regards
FSt1

"Krickette33" wrote:

I'm not sure what formula to use. I am trying to count in numerical order
down a column, ie 1,2,3,4 and so on. Rather than have to type each individual
number, I would like Excel to fill in the columns for me. I've done it once
before but can't remember the formula. Can someone help with this?