How do I make a list of numbers re-number itself, continue the sequence, after deleting rows?
D Dr.Alvixagon Mar 16, 2006 #1 How do I make a list of numbers re-number itself, continue the sequence, after deleting rows?
S Sloth Mar 16, 2006 #2 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
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
