MicroNugget: How to Use Autofill in Excel 2013

In this video, Chris Ward covers how to use AutoFill in Microsoft Excel 2013 to add dates, number series, and custom auto lists. This feature allows you to quickly put lists of serial data together and can be utilized anytime you have something that can go in a sequence or series.

The AutoFill function in Excel is used to populate serial or sequential data rapidly with minimal effort. Chris uses the example of a league schedule with seven different teams.

He’ll show you how to copy cell contents, fill in a series, and then replicate the data with and without formatting. There are several features available in the File > Options > Advanced section, and in this example, Chris will use the Edit Custom Lists function to create lists for use in sort and fill sequences.

This is beneficial when you’re using a structured, repeated list (e.g., the team names in the league) that isn’t already programmed into Excel (as days of the week or months of the year are).

AutoFill is a powerful function that’s relatively straightforward to use.

Start learning with CBT Nuggets:

[lottieluver]

I take my MOS Excel 2013 certification on Friday and I've been using these videos to study! I hope it helps

[vladimirs]

Thank you, Chris!
This has solved one of my problem! Series Jan, Feb...Dec didn't want to auto fill itself.
However, when I went to Custom Lists I've realized that these lists are Locale-specific! 

[BrownSkinSlim]

How do you autofill dates that are not in sequence? such as a date in cell A then the following date in D then the next in G and so on ?

[lottieluver]

Do you have any more tutorial videos for Excel 2013?? 

[MrBlackbrand]

Very good, straight to the point with informative tips along the way

[elhenryetasbarepetid]

Hi. Tables should use autofill without me saying so, right? Is there some kind of restriction about that? Because i have a table with 7 columns. The 1st one is raw data and all the others are formulas. Whenever i paste raw data and the table expands, 3 of the columns don't autofill the formula. All the otherones do. Any idea of how can i fix that? Thank you