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" <Lino@discussions.microsoft.com> wrote in message
news:5C78B3BA-9747-45AF-B23A-D81593F7C819@microsoft.com...
> 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.