autonumbering
 

how to autonumber a range of cells

What do you mean by auto nummber

You could do the following

a b
1 1 Enter 1 for the first cell
2 =max($A$1:A1)+1 then drag down
3 =max($A$1:A2)+1 it will produce this second formula
4
5

HTH


--

_______________________
Naz,
London


"Lino" wrote:

how to autonumber a range of cells

"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.