Learn how to use AutoFill in Excel to create a list of numbers, dates, month names, or weekday names when you drag the fill handle. Also learn how to create a custom list.
0:03 Drag the Fill Handle to create a numbered list
0:20 Use the CTRL+Drag shortcut
0:27 Fill a numeric pattern (10, 20, …)
0:33 Fill in Month Names (Jan, Feb, …)
0:40 Fill in Days of the Week (Mon, Tue, …)
0:55 Fill Dates by day, month, or year
1:06 Fill Times by hour or pattern
1:18 Increase a number at the end of text (Item 1, Item 2, …)
1:28 Quick intro to Flash Fill
1:45 How to create a custom list
NEXT – How to use Flash Fill in Excel:
👍Remember to Subscribe!
FOLLOW VERTEX42 HERE:
Instagram:
Facebook:
Pinterest:
Twitter:
MUSIC: Countdown, by Paper Planes, licensed via ArtList
Watch more new videos about Excel Office | Synthesized by Mindovermetal English
But how do I do this flash fill in phone app in excel
Good
Thanks very much.
Thank youuuuuuu !!!! Great Video
Thanks for It
This looks amazing! Would it possible to change the currency displaced from $ to my local currency?
I need a lie down. Just as I thought you were teaching a granny to suck eggs along comes Flash fill and custom list! BOOM!