How to Auto-Number Cells with a Regular Patternįor this method, you set your starting number in one cell and the next number in the series in the next cell. And in this article, I'll show you two methods of doing so: the first is a simple method, and the second lets you have dynamically numbered cells. But writing the number manually in each cell takes a lot of time.įortunately, there are methods that help you add numbers automatically. Numbering cells is a task often you'll often perform in Excel.
