Using Excel Custom Lists
What are Custom Lists used for? They are used mainly for SORTING or FILLING any regular Excel lists and tables in a specific user-defined order. Using the lists may save you a lot of time when frequent sorting or filling your lists is needed when working with Excel data.
Excel provides couple of built-in lists by default, as you can see below:
- in your selected cell type in any entry from the custom list, e.g. Jan, or Mon, etc.
- click on the small box at the bottom right corner and drag it any way you want to - down, up, right, left - to populate any number of cells, in rows or columns, with the list items.
There are also many "hidden" custom-like lists you can built and use easily as needed. Below are some examples of such lists that Excel accepts and readily auto fills for you:
Keep in mind that if you'd like to built a list of numbers only, like e.g. List9 above, the list must be formatted as text prior to including it as a Custom List.
Creating your own Custom Lists
To create and add your own Custom lists to those provided already in Excel you need to Edit Custom Lists. To do that follow these steps:
- type the values of the list you need to use quite frequently, like e.g. currency codes of some countries, in a column of your worksheet, as shown below
- select the cells with your entries
- go to File>Options>Advanced>General, find there the shaded Edit Custom Lists field and click on it
- in the box click Import, click OK; your list has been added to the Custom lists box and is ready to use.