Let's talk about how we can use auto fill to save time. In the first example
I have the text Scarf typed in here.
What happens if I drag down this fill handle? Let's just drag it until 10.
What's going to happen here?
It's going to copy the word scarf in the other cells.
Now here are the auto fill options.
Let's see what we have.
Default is to copy these cells.
We could fill also the formatting only. So without the text and we can also fill without formatting.
Flash fill is something we're going to take a look at in the next lecture.
So just let's take a look at these two.
Let's use control+Z to go back.
Now I'm going to format this in a blue color.
Now let's drag this down.
Default was copy cells.
But now let's change this to fill formatting only. That takes away the text puts in the formatting.
Let's go back and copy the cells.
Now let's copy them
but without that blue formatting.
So fill without formatting.
These options can come in handy especially later when we're going to be typing formulas in.
You might want to copy the formula down but not the formatting.
Now let's take a look at what happens to the number when we drag this down.
It's going to copy it.
So that was the default.
Now we have some more options.
Actually one more option and that's fill series.
So what's that all about?
The fill series is going to add one to each number. So you can use these as index numbers.
Now what about for month?
So what do you think is going to happen when I drag this down to here?
We can actually see it in that tooltip text.
It's going to go to the next month.
So the default for this wasn't to copy but is to fill the series because that's probably what most people
want to do when they type in January they pull it down.
They want it to go to the next month.
You could just have January if you wanted by switching this to copy cells. You again have the same options
you have before we can fill formatting only, fill without formatting, and fill months.
So in this case if I click on fill months it's basically the same thing as the fill series.
This also works if I had the full word here.
So if I have January drag these down, we can see the full word.
This is actually a custom list that's saved in excel
and we're also going to see this in a future lecture in this section.
Next let's take a look at weekday.
So what do you think is going to happen?
You can see it. We go to the next day and the next day.
So the default for this is again fill series.
We can switch to copy if you wanted to see Monday then again we have fill formatting only. Now here we
have more options.
We have fill dates and fill weekdays.
So what would be fill weekdays? That takes away the Saturday and Sunday.
So instead of Saturday and Sunday we get Monday and Tuesday.
Now let's take a look at Date. When I pull this down
it's adding one day to the other one. So again fill series is the default.
And now I have even more options.
I can fill weekdays I can fill months and fill years.
So let's take a look at fill months.
That adds one to the month, fill year that keeps the same date.
But goes to the next year and fill weekdays.
Then skips the weekend so 20th was a Saturday, Sunday is skipped right here.
Twenty seventh and twenty eighth are skipped because that's the weekend.
Okay so that's how the auto fill options can come in really handy when you work with different types
of data in Excel.