Excel AutoFill: Fill Months, Dates and Number Series
Excel AutoFill can save you from typing every month, day or number in a sequence. In this recorded lesson, I demonstrate the fill handle with months, weekday names, dates and number series. Once you understand the starting pattern, you can build worksheet headings and simple lists much faster.
Watch the Excel AutoFill lesson
Watch the Excel AutoFill lesson with Tom Fragale on YouTube.
This recorded tutorial uses an older Excel interface and sample dates from 2017. The dates are practice data, not a current schedule. Your version’s controls may look different.
Find the fill handle
Select a cell or a small range. The fill handle is the small square at the lower-right corner of the selection. Drag it across empty cells or down a column to extend the selection’s contents or pattern. Use a blank practice worksheet so you do not overwrite information you need.
Fill months and weekday names
Type January into a cell, select it and drag the fill handle to the right. Excel recognizes the month name and can continue the sequence with February, March and the remaining months. The same idea works with familiar day names, such as Monday and Tuesday.
This is useful for monthly report headings and weekly planning sheets. Check where the sequence ends: month names and day names repeat after the end of their cycle. Also remember that a list of weekday names is not the same thing as a calendar that excludes weekends and holidays.
Build a date sequence
Enter a date that Excel recognizes as a date, then use the fill handle to extend it. Review the resulting dates and the Auto Fill Options choices so the interval matches your goal. If you want weekly dates, start with two dates seven days apart, select both and extend that pattern.
After filling, check the first few dates and the final date. A date that looks right at a glance may still use the wrong month, year or interval.
Give number series a clear pattern
For a simple counting series, enter 1 and 2 in adjacent cells. Select both cells before dragging the fill handle. To count by fives, use 5 and 10 as your starting pair. Excel uses the difference between the selected starting values to continue the pattern.
If you drag from a single number, Excel may copy that number rather than count upward. Check the result and use the appropriate fill option, or undo and supply a two-cell pattern. AutoFill follows the information you give it; it does not know what your business list is supposed to mean.
Practice, then apply it at work
Try three small exercises: create twelve month headings, build a weekly date list and fill a number series from 10 to 100 in steps of 10. Check the results before using this technique in an important workbook.
New to worksheets? Start with entering, editing and organizing data in Excel. For tailored help, book a free 15-minute conversation about private training. Explore custom training services, live webinars and recorded courses.
Tom Fragale
Email: tom@pcwebinars.com
LinkedIn: https://www.linkedin.com/in/tomfragale
Website: https://pcwebinars.com