Automatic numbering
 

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.

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.

Automatic numbering
 

Melanie,
I'm guessing you mean rows other than the row headings. One of the expert
users on this forum may have a better solution that you wouldn't have to copy
into the row, but if you don't have a problem with copying a formula when you
insert a row, you can try =ROW()-n as the formula for the row number, with n
being the number less than the row header. If your row numbering starts on
row 5, you'd use =ROW()-4 and copy that all the way down. This way, as long
as you don't add rows above where you start your numbering, the formula will
be the same for each row.

"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.