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
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.