View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
perry perry is offline
external usenet poster
 
Posts: 14
Default 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.