View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sloth
 
Posts: n/a
Default Renumbering a list of numbers

Make the list numbers dependant on the row using the ROW() function.

Example: If you want the numbers to start on row 2, then use this formula
and copy down.

=ROW()-1

"Dr.Alvixagon" wrote:

How do I make a list of numbers re-number itself, continue the sequence,
after deleting rows?