How to Quickly Fill a Series of Numbers and Dates in Excel #shorts

In this #shorts video you'll learn how to quickly fill a large series of numbers and dates in Microsoft Excel. It's a much better and faster method than using the fill handle and dragging down.

Let’s connect on social:

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#MsExcel

[countduckula]

Brilliant concise visual solution to what a lot of people are missing [myself included], thanks.

[Keronin]

There are so many little things in Excel that I had no idea existed, but would make certain things faster/easier. This is one of them. I love it. Thanks for the useful information!

[cenevspeed_CARS]

Yes Leila! This method provides more functionality and has a wider usage according to me. Loving these jam packed shorts!!!

[michaelt]

Shut. The. Front. Door.

This was so easy I never would have found it without you. I can't begin to tell you the hours this will save me over time!! Thank you!

[MrBizaaro]

Thank you very much. I wondered why i used to get errors in dates if i just dragged them.. Can you also show how to create a datetime series ?

[chrism]

Thanks Leila, I always used to start a series then drag it down. This is a nice shortcut!

[teopirgaru]

i just love your channel...reviews, tips, the lot...thx and good luck

[sumitgaurav]

Hello Ma'am, I am watching your excel video everyday when you will uploaded on youtube. These has been supported and learning for shortcut in excel.Ma'am can you belived that I have been promoted to senior analyst for using shortcut.You are lucky person for my life as a growth my career in corporate level.
Thanks once again ma'am.

[tiongah]

wow, you probably save time of hundreds of people with just 1 minute! thanks1

[leslie]

My personal favourite is using the sequence formula in excel much easier

[adriangoodrich]

Wow. I never knew this feature was here! Like so much else I have learned from your videos, this will prove SO useful. It has to be said: you and your channel are wonderful! Thanks SO much!

[app]

For number i ussualy use row() formula because that is i think more flexible if we delete some rows, , ,

[amjan]

Oh, I've been needing this so badly recently!!!! I was dragging a series down hundreds of rows like a loser!!

[LEO_rumano]

Microsoft, please change rows by columns and columns by rows :))

[RajeshBachuRadhika]

Thanks for your valuable tips Leila. You are doing awesome as always does. Thanks again!

[wayneedmondson]

Hi Leila. Great tip! I often forget about Fill Series and do it manually. Strange that the default in the dialog is to fill rows vs. columns. Seems like columns should be the default.. my opinion. As always, thanks for sharing :)) Thumbs up!!

[HeatherMajors]

That is such a cool shortcut. Love all of your videos because you always show tips and tool I never knew to ask for.

[mplsmike]

Have to chuckle a little, been using Fill Series since, I don’t know, Excel 5? Alt-e-i-s is your friend!

[muhammadzohaib]

Which Excel Version is this ??? 2021 or office 365 ???
Because this option is not available in office 2019

[caliepher]

Can I do this for date whilst skipping 3 days each week???