How to Make an Autofill List in Excel – Tutorial

We may be compensated for your purchase of any of the products featured on this page – it helps us keep the lights on :)

Excel tutorial on how to use Autofill lists. We’ll go over what Autofill is, how to create a new Autofill list in Excel that can be reused in other worksheets, and how to modify a custom Autofill list.

What is Autofill in Excel???

Sometimes called autocomplete, an autofill is a list of words that can be automatically filled in your spreadsheet.

How does Autofill in Excel work?

Once you create a custom auto fill list, Excel will autopopulate the items in the list once a word from the list has been typed and the cell containing the word dragged to adjacent cells. This can save time and improve efficiency.

Excel already includes auto fill lists for months and days, but you can create a custom autofill list for items that are specific to your work, school or personal need. You could do a list with the names of all your students or staff, for example.