AutoFill Your Own Custom List

AutoFill Your Own Custom List

AutoFill Your Own Custom List

AutoFill Your Own List

Just like you AutoFill the days of the week and the months of the year in Excel, you can AutoFill your own list. Set up is easy!

Type your list into a range of cells on a worksheet and select it. Or, select from a worksheet that already has these values. From the File tab, select Options and then Advanced. Scroll to the bottom of the list of options and look for the Edit Custom Lists button under General.

CustomList

When you click it, it will show your range in the Import field. Click the Import button.

CustomList2

That’s it! Now, just type in any item in the list and click and drag your AutoFill handle. Your list will magically appear.

No Comments

Post a Reply