View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
CMack CMack is offline
external usenet poster
 
Posts: 2
Default Consecutive No'ing WHEN ADDING/DELETING ROWS

Thanks so much for your speedy response, Dave!

Dave Peterson wrote:
Maybe you can use a formula:

=row()
or
=row()-1
if your numbering starts in row 2.

Then just copy the formula down when you insert any new rows.

Got a spreadsheet that's consecutively numbered.
Need it to keep consecutively numbering as I add and/or delete rows

[quoted text clipped - 15 lines]

Help!