Excel Fill Number the right way using the SEQUENCE function

There are five ways to fill sequential numbers in Excel. One of the least used, but possibly the best way, is to use the SEQUENCE function. We will look at all five methods in this video, including using AutoFill and Fill series.

Chapters:
00:00 Introduction and example
01:15 Method 1
01:29 Method 2
01:57 Method 3
02:43 Method 4
03:20 Method 5
06:15 Closing remarks

SEQUENCE Function
The SEQUENCE function allows you to generate a list of sequential numbers in an array, such as 1, 2, 3, 4, 5, 6, 7.

Available for Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel for iPad and iPhone, and Excel for Android tablets.

Popular Excel Videos

#chrismenardtraining #microsoftexcel #chrismenard #msexcel

And make sure you subscribe to my channel!

-- EQUIPMENT USED ---------------------------------

-- SOFTWARE USED ---------------------------------

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!

[stefaniesrc]

I've always known there is a better way than 1, 2, select, drag but never knew what else to do. This is great!

[buchimaximus]

I've always thought there has to be a better way to fill in numbers. Awesome. Thanks

[rickchunko]

I like the sequence funcation and have already added it into some of my spreadsheets. Thanks!

[mytrueserenity]

Perfect! I was looking for just this type of functionality. I'll be using this from now on. Thanks, Chris!

[terrysmith]

Thanks for showing different ways to add numbers. Thanks

[davidkeown]

Thank you Chris, I watched this video with closed captioning on because my wife is watching TV right beside me and I could follow you very well from the captioning.

[MichaelBrown-lwkz]

Your instructions are great because you get right to the point and you keep it simple.

[nathaliehernandez]

Was struggling to find out how to do this. Came across your video and figured it out immediately! Thank you

[IsItTrueThat]

Great info, Chris. Love the little shortcuts you show just in demonstrating other features. Once in a while there is a benefit of using Page Layout, Sheet and then check, Print Row and Column headings. Mostly it would qualify as an inappropriate way of numbering rows though.

[lorenzoarodriguez]

Yes, this is new to me. I used the fill method most often, I will try this one now.

[dorothya]

Thank you, Chris! Very helpful. I knew there was a way to have the sequence automatically update. Enjoyed the video!

[roywilson]

Thanks for the video. I use the sequence function pretty often for this kind of thing but also use the Row - header Row especially if there is any danger of the dataset being changed to an Excel table - as we all know spilling functions and tables do not play nice together. This also avoids problems if you want to get the data into Power Query in the same workbook and forget to name the range to avoid it being automatically changed to a table.

[shanesalmon]

Thank you so much sir! This was very helpful

[mjreyes]

Thank you very much this saved me so much time on a report!

[mikedonnelly]

This is great, , , I just used it and it works wonderfully! This channel is great!

[papapws]

Nice presentation and good examples. I am going to use the sequence (count function). Thank you.

[ralphcabeltis]

I salute you bro. Thanks bro. You are the answered to my prayer! :)

[Robert_]

I've always used =Row()-Row(HeaderRow) but I will definitely give Sequence a try. Thanks Chris!

[irvingdetres]

I will use this feature. Thank you again Chris!

[jobsafety]

I will be using option #5.Thank you Much.