Training Video TECH TIP: Excel Autofill

Training Video Tech Tip - Excel Autofill | Legal MS Office Training

Check out this quick video tip about the autofill feature in Excel from the Affinity Insight live training session Excel Data Dive!

Microsoft Excel has a few features that I like to describe as pure magic; they save you time and improve accuracy without complex formulas. This month, we unleash the magic with autofill. (Text version below.)

2020.03 Excel Autofill



Autofill automatically populates data across multiple cells, simply by dragging and dropping.

Simple Patterns

When it comes to numbers and dates, if Excel can recognize your pattern, it can autofill. For simple patterns, start by typing the first number or date in the appropriate cell. Then drag and drop the autofill handle (found in the bottom right-hand corner of every cell) across the cells to be filled.

Complex Patterns

For more complex number or date patterns, type the first two numbers or dates in the appropriate cells. Then, select both cells and drag and drop the autofill handle across the cells to be filled.

Custom Lists

If you need more than numbers and dates, you can create a custom list. Start by typing each item in its own cell, either across a row or down a column. Select the cells. Open the file menu, click on Options. Under the Advanced Options, in the General group, click on the Edit Custom Lists button. In the Custom Lists dialog, click on the Import button, OK, and OK again.

Now you can enter an item from your list and autofill the rest. It’s magic!


If you are interested in more training videos, or if you're ready to create a culture of training in your organization, discover all that Affinity Insight has to offer.

Affinity Insight is a subscription membership program with 3 levels of membership available – Standard, Plus and Premium. The plans are based upon the level of service - not on the number of users in a firm. Yes, you read that right. As part of our introductory offer, the price is the same if you have 3 users, 30 users, or 300 users.

Find out all the details by going to Or, if you have any questions about the Excel autofill tip or Affinity Insight, contact us at 877-676-5492, or request a consultation. Our team of experts are ready to help!


Danielle DavisRoe

Written by Danielle DavisRoe

Danielle’s many responsibilities at Affinity include training, CLE/speaking, writing, management consulting, and document automation. Prior to joining the Affinity family, Danielle practiced family law. She discovered, however, that she enjoyed making efficient use of technology more than practicing law, making her a perfect fit for consulting. Danielle describes her superpower as “herding cats,” and her favorite parts of her job are making others’ jobs and lives easier.

Recent Posts