One way:

A1: 1
A2: =A1 + 1

copy down


In article ,
JICDB wrote:

I have a numbered waiting list with 500+ members. When someone in the middle
decides to cancel, I would like them to be renumbered automatically. Is this
possible? It isn't diffiecult to clear the numbered column and then use
autofill, but I want something more user friendly for my co-workers.