Create Custom Autofill Lists in Excel

While using Excel you might already know that you can easily get the list of names of the months and days of the week. Just give any and simply drag the fill handle and you will get the rest automatically.

It is super convenient and extremely useful when it comes to building data and making analysis and that too without any mistakes.

Ever wondered how Excel can pull this off? Well it is possible because these lists are provided in Excel by default. We call these lists Autofill lists.

But to your surprise probably, you can make your very own Custom Autofill lists to populate the cells just like we do it for months and days in Excel. And today's tutorial is about the same:

Create Custom Autofill Lists a.k.a AutoFill Series in Excel Super Easily

Hope you enjoy this video and if you have your own ideas about autofill lists in Excel then do let us know in the comments of this video.

Also don't keep your friends unaware of this video, share it all the way so that everyone can benefit. And don't forget to subscribe!