Thread: autonumbering
View Single Post
  #1   Report Post  
Vic Sowers
 
Posts: n/a
Default


"Lino" wrote in message
...
how to autonumber a range of cells


Enter into the first two cells in the column:
1
2

Then select both cells and dreag the little square down as far as needed.

- Or -

Enter
1
into the fist cell in the column and
=<the cell with 1 in it+1 (e.g. A1+1)

Then select the second cell and drag it down as far as needed.