How to Create an Alphanumeric Custom List in Excel 2007

Create the List
1. Open Excel and click on the Office button, which is located in the top left-hand corner of the window.
2. Click the 'Excel Options' item from the menu that drops down.
3. Click on the category labeled 'Popular.' Locate the section called 'Top options for working with Excel.' Click the 'Edit Custom Lists' item in this section.
4. Click the 'New List' option located in the 'Custom Lists' box.
5. Type the first item of the custom list. Choose any combination of alphanumeric text characters. Enter the item into the 'List entries' box. Press the Enter key on the keyboard.
6. Type the rest of the list items, pressing Enter after each list item.
7. Press the 'Add' button when the list is complete. The new list displays in the 'Custom lists' box.
8. Press the 'OK' button, and then press it again to close out the open windows. The custom list is now created in Microsoft Excel 2007.
Use the Custom List
9. Type the first custom list item into a cell in the Excel 2007 window.
10. Type the second list item in an adjacent cell to the first item. This may be entered in a cell on any of the four sides of the first list item.
11. Select the two cells by clicking on one and dragging with the mouse to the other. The two cells will appear with a dark, translucent overlay.
12. Hover the mouse over the lower right corner of either cell. The mouse cursor will change to a small black ' ' sign.
13. Drag the mouse in the desired direction for the completed list. Drag for as many cells as you desire. Release the mouse, and the custom list is filled into all the cells.