...................................... The problem with both this and
Paul's
method is that if you insert a row you end up with a hole in the
numbering.

That being the case you would be better with:

=ROW()-1

in A2 and copied down. You will still get a hole in the numbers if you
insert a new row but now at least all youhave to do is to drag down the
formula from the row above.

HTH

Sandy
--
to e-mail direct replace @mailinator.com with @tiscali.co.uk


"Sandy Mann" wrote in message
...
Or you can enter 1 in A2, 2 in A3, highlight both cells and copy down
using
the fill handle to give you a list. The problem with both this and Paul's
method is that if you insert a row you end up with a hole in the
numbering.

HTH

Sandy

--
to e-mail direct replace @mailinator.com with @tiscali.co.uk


"Javster95" wrote in message
...
Is there a way to automatic number a spreadsheet? For instances... if I
were
to start on column A and row 2 with number 1, would this be possible to
continue numbering going down the spreadsheet? Please assist.