Is the fill handle smart enough to fill in quarters and halves? Maybe. Maybe not.
Episode #1183 shows you why.
Also, in this episode, a challenge to users - view the podcast for details
Episode #1183 shows you why.
Also, in this episode, a challenge to users - view the podcast for details
Transcript of the video:
MrExcel podcast is brought to you by ”Easy-XL”!
Hey welcome back, it’s another MrExcel netcast, I'm Bill Jelen.
I was in Milwaukee last week doing the Power Excel seminar for the Milwaukee Institute of Internal Auditors.
And of course, you know, I always show the fill handle, how you can type January and grab the fill handle, drag.
It'll type the month names for you, and it works with the days of the week, and it works with abbreviations, you know, for both the months in the days.
If you put a date in there, Ctrl+; puts today's date, grab the fill handle, drag, it’ll fill in the next day.
I actually have to get it though, the next day, the next day, the next day!
Another cool trick, if you need to just fill in the week days, right-click the fill handle, drag, and choose Fill Weekdays, it fills in just the Monday-Friday dates.
And, of course, with quarters it's smart enough that after quarter 1 it starts over again, alright, so we have all of that, Room 101, it goes on.
And then someone in the audience was trying, they had a laptop, you know, and they said “Hey, check this out, Q1, Q2, H1!
It's smart enough to go Q3, Q4, H2!” I was like “Wow, I never knew that was there, that is so cool!” But it turns out it's not that cool at all, let me undo, and when I drag farther, see it goes up to H3, so they don't actually understand the concept.
What's happening here, if we have A1, A2, B17 and drag that, they're going to extend them both in some nice little patterns, A3, A4, B18, A5, A6.
B19.
So actually, I'm issuing a challenge to you, if you've discovered some weird thing that the fill handle does like Q1, Q2, H1, send that in to bill@mrexcel.com.
The best weird thing that the fill handle does will put on a future podcast, and give you a free MrExcel bubble tumbler with the Excel tag cloud, there we go.
Hey, I want to thank you for stopping by, we'll see you next time for another netcast from MrExcel!
Hey welcome back, it’s another MrExcel netcast, I'm Bill Jelen.
I was in Milwaukee last week doing the Power Excel seminar for the Milwaukee Institute of Internal Auditors.
And of course, you know, I always show the fill handle, how you can type January and grab the fill handle, drag.
It'll type the month names for you, and it works with the days of the week, and it works with abbreviations, you know, for both the months in the days.
If you put a date in there, Ctrl+; puts today's date, grab the fill handle, drag, it’ll fill in the next day.
I actually have to get it though, the next day, the next day, the next day!
Another cool trick, if you need to just fill in the week days, right-click the fill handle, drag, and choose Fill Weekdays, it fills in just the Monday-Friday dates.
And, of course, with quarters it's smart enough that after quarter 1 it starts over again, alright, so we have all of that, Room 101, it goes on.
And then someone in the audience was trying, they had a laptop, you know, and they said “Hey, check this out, Q1, Q2, H1!
It's smart enough to go Q3, Q4, H2!” I was like “Wow, I never knew that was there, that is so cool!” But it turns out it's not that cool at all, let me undo, and when I drag farther, see it goes up to H3, so they don't actually understand the concept.
What's happening here, if we have A1, A2, B17 and drag that, they're going to extend them both in some nice little patterns, A3, A4, B18, A5, A6.
B19.
So actually, I'm issuing a challenge to you, if you've discovered some weird thing that the fill handle does like Q1, Q2, H1, send that in to bill@mrexcel.com.
The best weird thing that the fill handle does will put on a future podcast, and give you a free MrExcel bubble tumbler with the Excel tag cloud, there we go.
Hey, I want to thank you for stopping by, we'll see you next time for another netcast from MrExcel!
