How do you REALLY get Excel to Autonumber consecutively?
 

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

How do you REALLY get Excel to Autonumber consecutively?
 

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

Otto wrote:

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

How do you REALLY get Excel to Autonumber consecutively?
 

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

"Otto" wrote:

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

How do you REALLY get Excel to Autonumber consecutively?
 

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

On Sep 23, 10:44*pm, Otto wrote:
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

How do you REALLY get Excel to Autonumber consecutively?
 

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

Hope this helps,

Hutch

"Otto" wrote:

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

How do you REALLY get Excel to Autonumber consecutively?
 

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

"Otto" wrote:

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

How do you REALLY get Excel to Autonumber consecutively?
 

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

On Tue, 23 Sep 2008 14:44:07 -0700, Otto
wrote:

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