Click here for great value web hosting.

ALL ABOUT OFFICE

HOME

ACCESS

EXCEL

WORD

OUTLOOK

POWERPOINT




Search for
 

help


EXCEL

Custom Lists

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 below.

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 Excel’s 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.

webmaster@allaboutoffice.co.uk