Create a numbered list the proper way in Excel
Numbered lists are a great way of staying on top of work or personal tasks. However, not all methods are equal.
Suppose we have a task list in A1:B6, with the headings in the first row, the numbers on the left, and the tasks on the right.
Here are two commonly used methods:
Manual fill
Input 1 in A2, 2 in A3, and then select these two cells and double-click the fill handle to extend the sequence.
Increment formula
Input 1 in A2 and then =A2+1 in A3. Use the fill handle to generate =A3+1 in A4, A4+1 in A5, and so on.
The problem with both is if you add or delete items, the number column does not update automatically.
The solution is to use a dynamic formula that creates a spilled range of sequential numbers based on the number of non-empty cells in column B. It’s also necessary to subtract 1 to exclude the header from the count.
It looks like this:
=SEQUENCE(COUNTA(B:B)-1)Now, you have a robust list that lets you add and delete items without having to do any extra work!
