There is more than one way to do this, so we will show you two different options and you can decide which solution is better for you. The steps in this article will show you how to create a sequence of consecutive numbers in a row or column.

Our tutorial below will show you two different ways to achieve this result. But doing it manually can be tedious, and there’s always the possibility of a typo that could create problems in the future.įortunately Excel 2013 has a feature that will automatically fill rows or columns with a series of incrementally increasing numbers.

It’s a common task in Microsoft Excel 2013 to fill a row or column with a series of consecutive numbers.