Excel: Custom Lists Option

With built-in custom lists, you can fill data either by days of the week or months of the year. Optionally, you can create your own custom lists to sort by any other characteristic that doesn’t sort well alphabetically. A custom list can correspond to a cell range or you can enter the list in the Custom Lists dialog box as shown in the video. For a custom list that contains numbers only, such as 0 through 100, you must can create a list of numbers easily. A custom list can only contain text or text that is mixed with numbers. In the Custom Lists dialog box, import the list by selecting the range of cells that have the list. Alternatively, you can also enter the name manually in the List Entries Box separated by comma or each name in a new line. One of the fastest ways would be to have January in a cell, February in an adjacent cell and then use the fill handle to drag and let Excel automatically fill in the rest. Excel is smart enough to realize that you want to fill the next month in each cell in which you drag the fill handle. Month names are quite generic and therefore it’s available by default in Excel. But what if you have a list of department names or employee names or product names etc, and you want to do the same. Instead of manually entering these or copy-paste these, you want these to appear magically when you use the fill handle just like month names.