View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default 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