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?