How to create a number sequence in excel formula
By
SpreadCheaters
Page last updated:
19/11/2022 |
Next review date:
19/11/2024
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.
