How to Use AutoFill in Excel

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:
• How to Use Flash Fill ...
👍Remember to Subscribe!
FOLLOW VERTEX42 HERE:
Instagram: / vertex42
Facebook: / vertex42
Pinterest: / vertex42
Twitter: / vertex42
MUSIC: Countdown, by Paper Planes, licensed via ArtList

[@masterisminimi1125]

No BS, straight to the point! Thank you so much!

[@abdullahtatari2834]

Thank youuuuuuu !!!! Great Video

[@TheMewiya]

Wow! Thank you!

[@nayanjyotidas4676]

Thanks alot really helpful

[@soelwin4351]

Thanks very much.

[@salomajhi1313]

Thanks for It

[@shizmosaic]

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!

[@shizmosaic]

Guessing the 7 dislikes are from professional egg suckers.

[@angelinecherry2846]

This looks amazing! Would it possible to change the currency displaced from $ to my local currency?

[@vertex42]

Here is an old video, still applicable: kzbin.info/www/bejne/sGPQXmeMo9GmnLM

[@rashimittal3905]

Good

[@rashimittal3905]

But how do I do this flash fill in phone app in excel