Sequential number - adding and deleting rows

Is there a way to squentially number a column so that if you insert or delete
rows in the middle the numbers will readjust? if you use A1+1 and copy it
down, you get a #REF if you delete; and a blank cell if you don't (and then
you have to use the fill handle from above the blank cell to resequence?

Any assistance would be greatly appreciated.

Suzan

Enter the formula =ROW() in the first cell and copy it down. (You might
like to add or subtract a constant depending on how you want the cells
numbered). When you delete a row this will automatically re-number.

If you insert a row, though, you will still need to copy the formula
down, so this only partially meets your requirements. There again,
though, you might have other formulae to copy into the new row, so you
might do this at the same time.

Hope this helps

Pete

Thanks! That is really going to help. Once again the board came thru. Love
you guys and gals!

/s

"Suzan" wrote:

> Is there a way to squentially number a column so that if you insert or delete
> rows in the middle the numbers will readjust? if you use A1+1 and copy it
> down, you get a #REF if you delete; and a blank cell if you don't (and then
> you have to use the fill handle from above the blank cell to resequence?
>
> Any assistance would be greatly appreciated.
>
> Suzan