How to Use AutoFill in Excel
HTML-код
- Опубликовано: 6 окт 2019
- 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
No BS, straight to the point! Thank you so much!
Wow! Thank you!
Thank youuuuuuu !!!! Great Video
Thanks very much.
Thanks alot really helpful
Thanks for It
Good
This looks amazing! Would it possible to change the currency displaced from $ to my local currency?
Here is an old video, still applicable: ruclips.net/video/z2m-4VnlsfQ/видео.html
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!
Guessing the 7 dislikes are from professional egg suckers.
But how do I do this flash fill in phone app in excel