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

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

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