How to create a number sequence in excel formula

You can watch a video tutorial here.

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

– 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.