1 00:00:02,120 --> 00:00:06,689 Let's talk about how we can use auto fill to save time. In the first example 2 00:00:06,770 --> 00:00:10,040 I have the text Scarf typed in here. 3 00:00:10,280 --> 00:00:14,780 What happens if I drag down this fill handle? Let's just drag it until 10. 4 00:00:15,410 --> 00:00:16,660 What's going to happen here? 5 00:00:16,670 --> 00:00:20,570 It's going to copy the word scarf in the other cells. 6 00:00:20,570 --> 00:00:23,860 Now here are the auto fill options. 7 00:00:23,870 --> 00:00:25,340 Let's see what we have. 8 00:00:25,340 --> 00:00:27,890 Default is to copy these cells. 9 00:00:27,890 --> 00:00:35,870 We could fill also the formatting only. So without the text and we can also fill without formatting. 10 00:00:35,970 --> 00:00:38,960 Flash fill is something we're going to take a look at in the next lecture. 11 00:00:38,960 --> 00:00:41,250 So just let's take a look at these two. 12 00:00:41,270 --> 00:00:44,030 Let's use control+Z to go back. 13 00:00:44,120 --> 00:00:46,790 Now I'm going to format this in a blue color. 14 00:00:46,790 --> 00:00:49,030 Now let's drag this down. 15 00:00:49,040 --> 00:00:51,090 Default was copy cells. 16 00:00:51,230 --> 00:00:58,190 But now let's change this to fill formatting only. That takes away the text puts in the formatting. 17 00:00:58,250 --> 00:01:00,770 Let's go back and copy the cells. 18 00:01:00,770 --> 00:01:02,210 Now let's copy them 19 00:01:02,240 --> 00:01:04,569 but without that blue formatting. 20 00:01:04,580 --> 00:01:06,950 So fill without formatting. 21 00:01:06,950 --> 00:01:12,500 These options can come in handy especially later when we're going to be typing formulas in. 22 00:01:12,500 --> 00:01:16,770 You might want to copy the formula down but not the formatting. 23 00:01:16,770 --> 00:01:21,640 Now let's take a look at what happens to the number when we drag this down. 24 00:01:21,770 --> 00:01:23,010 It's going to copy it. 25 00:01:23,030 --> 00:01:24,880 So that was the default. 26 00:01:24,890 --> 00:01:27,440 Now we have some more options. 27 00:01:27,500 --> 00:01:31,190 Actually one more option and that's fill series. 28 00:01:31,190 --> 00:01:32,450 So what's that all about? 29 00:01:32,510 --> 00:01:39,410 The fill series is going to add one to each number. So you can use these as index numbers. 30 00:01:39,410 --> 00:01:40,710 Now what about for month? 31 00:01:40,910 --> 00:01:44,520 So what do you think is going to happen when I drag this down to here? 32 00:01:44,570 --> 00:01:48,140 We can actually see it in that tooltip text. 33 00:01:48,140 --> 00:01:50,260 It's going to go to the next month. 34 00:01:50,810 --> 00:01:56,690 So the default for this wasn't to copy but is to fill the series because that's probably what most people 35 00:01:57,020 --> 00:01:59,650 want to do when they type in January they pull it down. 36 00:01:59,750 --> 00:02:02,570 They want it to go to the next month. 37 00:02:02,630 --> 00:02:09,380 You could just have January if you wanted by switching this to copy cells. You again have the same options 38 00:02:09,380 --> 00:02:15,110 you have before we can fill formatting only, fill without formatting, and fill months. 39 00:02:15,140 --> 00:02:21,360 So in this case if I click on fill months it's basically the same thing as the fill series. 40 00:02:21,390 --> 00:02:26,240 This also works if I had the full word here. 41 00:02:26,240 --> 00:02:31,020 So if I have January drag these down, we can see the full word. 42 00:02:31,040 --> 00:02:34,620 This is actually a custom list that's saved in excel 43 00:02:34,700 --> 00:02:39,590 and we're also going to see this in a future lecture in this section. 44 00:02:39,590 --> 00:02:41,400 Next let's take a look at weekday. 45 00:02:41,420 --> 00:02:43,740 So what do you think is going to happen? 46 00:02:43,760 --> 00:02:46,850 You can see it. We go to the next day and the next day. 47 00:02:46,850 --> 00:02:50,090 So the default for this is again fill series. 48 00:02:50,090 --> 00:02:56,690 We can switch to copy if you wanted to see Monday then again we have fill formatting only. Now here we 49 00:02:56,690 --> 00:02:58,370 have more options. 50 00:02:58,370 --> 00:03:00,830 We have fill dates and fill weekdays. 51 00:03:00,830 --> 00:03:05,720 So what would be fill weekdays? That takes away the Saturday and Sunday. 52 00:03:05,720 --> 00:03:09,690 So instead of Saturday and Sunday we get Monday and Tuesday. 53 00:03:09,710 --> 00:03:13,050 Now let's take a look at Date. When I pull this down 54 00:03:13,220 --> 00:03:17,930 it's adding one day to the other one. So again fill series is the default. 55 00:03:17,930 --> 00:03:20,800 And now I have even more options. 56 00:03:20,900 --> 00:03:24,730 I can fill weekdays I can fill months and fill years. 57 00:03:24,740 --> 00:03:27,560 So let's take a look at fill months. 58 00:03:27,560 --> 00:03:33,380 That adds one to the month, fill year that keeps the same date. 59 00:03:33,380 --> 00:03:36,860 But goes to the next year and fill weekdays. 60 00:03:36,980 --> 00:03:43,520 Then skips the weekend so 20th was a Saturday, Sunday is skipped right here. 61 00:03:43,520 --> 00:03:47,790 Twenty seventh and twenty eighth are skipped because that's the weekend. 62 00:03:47,850 --> 00:03:54,980 Okay so that's how the auto fill options can come in really handy when you work with different types 63 00:03:55,040 --> 00:03:56,450 of data in Excel.