- Choose Tools → Options.
- Click the Custom Lists tab.
- Enter the items in your list.
You can now utilize the list in all Excel workbooks by entering one item and dragging the fill handle.
If you create a custom AutoFill list, you can sort based on that list. For example, if you create an AutoFill list “High, Medium, Low” you can sort data and all the “High” will be first, the “Medium” second and the “Low” third! Just click the Options button in the Sort dialog box, then select your custom list from the First key sort order drop-down list.