Automatic numbering
A simple formula A2 = A1+1. Cell A1 contains your starting number. Then copy
this down the column. When you insert a new row the row below the inserted
one will need to point to the new row instead of the old row.
Hope this helps.
"Melanie needs help" wrote:
How do I setup a formula that will automatically update my number sequence if
I add or delete a row. for instance...I have rows numbered
1,2,3,4......etc.. I insert a row between 2 and 3 I need that row to
automatically update to the appropriate sequence.
|