How to create a number sequence in excel formula
You can watch a video tutorial here.
![](https://spreadcheaters.com/wp-content/uploads/FINAL-Image-How-to-create-a-number-sequence-in-excel-formula.jpg)
You have a table of data and you would like to add a list of numbers to it using a formula.
There’s an easy way to do this:
Step 1 – Type the formula
![](https://spreadcheaters.com/wp-content/uploads/Step-1-How-to-create-a-number-sequence-in-excel-formula.gif)
– Select the cell that you want to start your list in.
– Type =TEXT(ROW(A1),”000-000″) into the formula bar.
– Select the cell with your formula again and drag your mouse down to the end of your range.
– A list of increasing numbers will have been created.
This is an easy way to make a list of numbers in Excel without using VBA.