How do you REALLY get Excel to Autonumber consecutively?

[Otto]

I have followed both sets of the instructions to the letter but can only get
repetitive numbering.. i.e. 1,1,1,1,1,. I want consecutive just like the
instructions say I am going to get 1,2,3,4,5,... thanx

 

[Bob I]

put in 1, Enter, 2, enter, Select both cells and then drag the corner of
the border down to fill.

 

[Richard]

HOME
EDITING
FILL
SERIES
ENTER "1" in step value box

 

[Pete_UK]

Which instructions are these?

Put 1 in A1 and 2 in A2, then highlight both cells and then drag the
fill handle (the small black square in the bottom right corner of the
highlighted area) down as far as you need.

Alternatively, put 1 in A1, highlight the cells you want this to apply
to (eg A1:A15), click on Edit | Fill | Series (which should default to
an increment of 1) and click OK.

There are quite a few other ways, as well.

Hope this helps.

Pete

 

[Tom Hutchins]

Hold down the Ctrl key while you drag the starting cell's fill handle.

Hope this helps,

Hutch

 

[JasonP CCTM LV]

Cell A1 enter 1
Cell A2 enter =A1+1
Copy A2 down as far as you need to

 

[Gord Dibben]

One more................

Enter 1 in A1

Right-click on the fill handle and drag down.

Release button and select "Fill Series"


Gord Dibben MS Excel MVP