If you’re still using the Autofill handle to create number series, keep reading - we can’t have you being bullied at work for your outdated Excel skills 😛 Today we’re going to learn how to go from 0 to 100 real quick using the SEQUENCE function. The sequence fun-ction (get it?) is a flashy little function that allows us to quickly create custom number series in Excel.
To create a number series from 1 to 10,000 using the sequence function, all we have to do is enter the sequence function, enter 10,000 as the row argument because we’re creating a series that contains 10,000 rows, and that’s it! We now have a numbered list from 1 all the way to 10,000. We could also use the sequence function’s arguments to create a variety of customizations - let’s review those before we dive in:
- Row Argument - the number of rows the number series contains
- Column Argument - the number of columns the series contains
- Start Argument - the number the series should start on
- Step Argument - the amount each sequential number in the series increases by
It’s important to note that if we omit any of these arguments, Excel will automatically set them equal to 1. We can use these arguments to create any number of possibilities! Let’s say, for example, we wanted to generate our series across a row instead of down a column - all we would do is enter the sequence function and enter 10,000 as the column argument rather than the row argument and our series will fill in the columns to the right.
Will you make the switch? Are you ready to create number series like the pros? Ditch the autofill handle and try the sequence function!
