Sequential number - adding and deleting rows

S

Suzan

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
 
P

Pete

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
 
S

Suzan

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

/s
 
Top