=ROW() in your cells.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"DL" wrote in message
...
xforgive the lack of ecel lingo, but...

i'm trying to create a column of sequential numbers. right now i have the
formula a2=a1+1, a3=a2+1, etc. if i delete row 4 (for example), all
numbers
downward are in error, since the a4 formula is erased. is there anyway to
delete a row without disrupting the sequence? can they be reformulated
automatically?