You could dodge that as well with
=ROW()-ROW($B$2)+1
where B2 represents the cell where you'd put the formula, this will adapt to
inserted rows
--
Regards,
Peo Sjoblom
"Sandy Mann" wrote in message
...
...................................... 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.
|