Hidden Excel Fill Series Tricks to Impress Your Co-workers

Generating a list of dates or numbers is a super common task. In this video I’m going to show you some little known Excel Fill Series shortcuts you can use everyday.

0:00 How to use Fill Series in Excel
0:21 List Dates with Left Click
0:36 List Dates with Right Click
1:10 List Bi-monthly Dates
2:08 List Sequential Numbers
2:22 List Odd Numbers
2:42 List of Numbers a Specific Length
3:17 List of Dates a Specific Length
3:44 List Date Series
4:12 Fill Series Right-click Menu

[MegaTrickykid]

all the best for 2023 and many thanks for this useful video!

[antique-bsbb]

Thanks. Most of the simpler sequential fills can be done in a more natural way. Type in the first number of a sequence, and the second below it (say 7 then 10). Select both and left click drag the fill box down as normal. 7, 10, 13,
Without any right clicking or specialist tool. Works with dates too. And much easier to teach / remember.

But thanks for the full "fill" details, a lot was new to me.

[vijayarjunwadkar]

Great tutorial as usual Mynda! Thank you for helping us understand and use Excel better for our work everytime! Happy new year and stay blessed!

[stevebulls]

As always, Mynda, a gem of a tutorial!! Thank you!

[endthefed]

Your videos never cease to amaze me! Thank you for sharing your knowledge with the rest of us

[steven.h]

❤ _1/2_ cell distance, handle drag release 👍😎✊

[Luciano_mp]

Great tips Mynda. I liked, useful! Thank you...

[snicho]

Great tips as always, Mynda!
Thanks for identifying Bob's Mixed Dates fill. I definitely hadn't seen that one before.
It's a shame that it only appears to work when filling from two dates; three or more dates just fill the same values.

[hamayoonarif]

Your this video encouraged me to continue learning excel. Thank you for the great tips and tricks.

[darrylmorgan]

Hi Mynda!Would Like To Wish You, Phil And The Children A Very Happy Healthy New Year.Great Tips To Start 2023...Thank You :)

[SUBHUSARAHANA]

Very Useful Tips, We don't use it generally.

[mohameda]

Hello, thank you for your videos could you please advise if I could use your excel dashboard for work purposes?

[nobertmazunze]

Super helpful. Thank you.

Can you please assist me. My Excel formula depends on data I receive from a website every morning. My problem is, when new data comes, data from previous day recalculates & affects current day's value as it is also dependent on the previous day value. How can I prevent this?

[marcusfranconium]

I must say that the last 2 years have been big boosts to beeing user friendly . Even my mother that has zero knowledge of computers, finds it easy to learn .
Just like the old work book format of windows XP exell and word light versions easy to learn and verry user friendly .

[technicaldata]

Ma'am, Your Upload Are Always Great 👍. Can You Please Share Some Shortcut Keys For Data Formatting..

[super-sal]

Hi can you advise how to rectify issue of intellisense stop working in excel power query and also in power bi pro? I have tried reinstalling, repairing and restarting methods but if you have better solution please share. Thanks.

[cooljoker]

can you please do some trade journal tracker this what needs of data
Date $ Risk Ratio % Return Return % Coms Result Actual Balance
and we can trade more one time in same day so we need to see the actual balance
and we need chart of the actual balance will be based on day how the day finished
mybe we lose the fisrt trade and win the 2 so the balnce will be two value in the same day with different time
this is the only thing i couldnt do when i tried to creat my excel
so please if you can do a avideo how to creat one and we are futures traders we are too much and no one did this and only few and the just show how it works to sell it and we need to created one customized for each one