Excel - Cool Fill Handle Tricks Including Filling 1, 2, 3 - Episode 1977
Microsoft Excel Tutorial - Trick to allow the fill handle to fill 1, 2, 3 instead of giving you 1, 1, 1.
Welcome to the MrExcel netcast, where we bring you the best tips and tricks for mastering Excel. In this episode, we'll be diving into the Fill Handle feature and all the cool tricks you can do with it. So grab your favorite beverage and get ready to learn some new Excel skills.
We all know how to use the Fill Handle to quickly fill in a series of numbers or dates. But did you know that it can also work with months, days of the week, and even quarters and years? That's right, Excel is smart enough to understand abbreviations and different formats for these series. But there's one tricky scenario that always stumped me - filling in quarters and years together. That is, until I learned the secret of using "1Q" at the beginning of the series. Trust me, it will save you a lot of frustration.
But what about when you need to fill in a series of numbers, and Excel just keeps giving you 1s? Don't worry, there's a simple solution for that too. Just hold down the CTRL key while dragging the Fill Handle, and Excel will automatically count up for you. It's a little-known trick that can save you a lot of time and effort. And if you forget to hold down the CTRL key, don't worry - you can still fix it by holding down the CTRL key while dragging the Fill Handle again.
But the Fill Handle isn't just for numbers and dates. You can also use it to fill in weekdays, months, and even years. Just right-click and drag the Fill Handle, and you'll see options for filling in weekdays, months, or years. And if you need to fill in specific days of the year, like the 15th and last day of each month, we've got a trick for that too. Just select both dates, right-click and drag the Fill Handle, and choose "Fill Months". It's a handy trick that can save you a lot of time when working with payroll or other recurring tasks.
All of these tips and more can be found in our book, "MrExcel XL". With over 40 tips, cartoons, jokes, and more, it's the ultimate guide to mastering Excel. So go ahead and click the "i" in the top-right corner to order your copy today. And don't forget to subscribe to our channel for more Excel tips and tricks. Thanks for watching, and we'll see you next time on the MrExcel netcast.
Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/
You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-...
Table of Contents:
(00:00) Excel Fill Handle for 1-2-3
(00:19) Fill Handle Tricks in Excel
(00:33) Fill Months
(00:43) Filling Week Days
(00:57) Filling quarters
(01:19) Trick for filling quarters and years
(01:45) Fill Handle Fails for Numbers
(02:16) Holding down CTRL key while dragging
(03:30) Autofill Drop-Down
(03:40) Fill 1-2-3 Using Blank Cell
(03:50) Filling dates
(04:03) Filling weekdays
(04:19) Filling with specific days of the week
(04:30) Filling months
(04:45) Filling specific days of the year
(05:07) Clicking Like really helps the algorithm
#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial #excelfillhandle
This video answers these common search terms:
how to autofill month and year in excel
how to drag months in excel autofill
fill handle for weekdays
how to do fill handle in excel
how to add fill handle in excel
how to do the fill handle in excel
how do i use the fill handle in excel
how to fill date series in excel
excel how to dates to fill down
how to autofill dates in excel rows
how to autofill date in excel
how to excel auto fill dates
how to automatically fill in date in excel
filling in numbers in excel
how to make numbers fill in series on excel
how to autofill numbers in sequence in excel
how do i autofill numbers down in excel
how to fill a series of numbers in excel
how to fill excel row with numbers
how to fill month series in excel
how to autofill month series in excel
The fill handle is great for Months, Weekdays, Quarters, and Dates, but why won't it fill 1, 2, 3? This episode shows many workarounds. Also includes:
You can fill a series by using the Fill Handle
You can drag down or right
Filling months works automatically
Filling weekdays works automatically
Type in ALL CAPS to have the fill be all caps
Abbreviations work for months and weekdays
For years and quarters: 1Q-2016
Any word followed by a number works
Hold down Ctrl key to have 1 fill to 1 2 3
You can press Ctrl after you start dragging
Hold down Ctrl to copy dates instead of filling
Right-click and drag to fill weekdays or months or years
Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads...
Watch video Excel - Cool Fill Handle Tricks Including Filling 1, 2, 3 - Episode 1977 online without registration, duration hours minute second in high quality. This video was added by user MrExcel.com 04 August 2016, don't forget to share it with your friends and acquaintances, it has been viewed on our site 3,974 once and liked it 73 people.