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:
How you can use them? Here is the way (if you haven't used them never before):
- 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:
