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