formula to insert a row of consective numbers in a columm (1tru 5

[Guest]

need to know the forumla to insert numbers automatlly in columm starting wth
number3000 to 3500

 

[Bernard Liengme]

1) In a1 enter 3000, in A2 enter 3001; pull the fill handle (small solid
square at bottom right corner of A2) down to get 5000
2) In A1 enter 3000; in A2 enter =A1+1; pull the fill handle (small solid
square at bottom right corner of A2) down to get 5000
3) Use Edit | Fill
best wishes
Bernard

 

[Gord Dibben]

There are several ways to do this.

1. Enter 3000 in A1 then in name box type A1:A500 then Enter.

Edit>Fill>Series>linear>step value 1 and OK

2. Enter 3000 in A1 and then right-click on A1 fill handle and drag down to
A500. Release button and select "fill series"

3. Enter =Row(3000) in A1 then drag/copy down to A500

4. Enter 3000 in A1 and in A2 enter =A1+1

Drag/copy down to A5000

None of these are "automatic" for that you would need a macro.


Gord Dibben MS Excel MVP