You can create your own lists to use
with AutoFill and sorting, this is done by clicking on the Tools
drop-down menu and choosing Options.
Click on the Custom Lists tab and you will see the window shown
Type your list in the List
Entries box, hitting Enter after each entry.
When your list is complete, click the Add button and your list
will be added to Excels store of Custom Lists, in the diagram below you can
see we have added a custom list of Roman numerals.
If your list of values is available
on a spreadsheet you can use the Import list from cells box to highlight
the list and create a new custom list from it.
You will now be able to type the
first two entries of your list in adjacent cells and AutoFill
will be able to complete the other entries or you can choose your list from the
Options button in the Sort window to sort your data in
the order given in your list.
Click here to
return to the Excel index.