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

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

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

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
"ray" wrote in message
...
need to know the forumla to insert numbers automatlly in columm starting
wth
number3000 to 3500

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

There are several ways to do this.

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

EditFillSerieslinearstep 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

On Mon, 22 Oct 2007 10:55:01 -0700, ray wrote:

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