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.
When you click it, it will show your range in the Import field. Click the Import button.
That’s it! Now, just type in any item in the list and click and drag your AutoFill handle. Your list will magically appear.