View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Bondi Bondi is offline
external usenet poster
 
Posts: 94
Default Create a numerical sequence in a column: From 1 to ....


Depechez wrote:
I want to automatically generate a sequence of numbers from 1 to....X without
typing them all. How?


Hi Depechez,

You could type in 1 in A1 and 2 in A2.
Then highlight them and pull the autofill handle (The little black
square in the buttom right cornor of your highligted selection) to the
row you want to.

Regards,
Bondi