In the Custom Lists dialog box, import the list by selecting the range of cells that have the list. In the General option, click on the ‘Edit Custom Lists’ button (you may have to scroll down to get to this option). Click on the Advanced option in the left-pane. This will open the ‘ Excel Options‘ dialog box All you need to do is type the first two in the list and drag.īelow are the steps to create your own Custom List in Excel: This way, the next time you need to get all the departments name in one place, you don’t need to rummage through old files. Now, suppose you want to create a list of departments that you often need in Excel, you can create a custom list for it. As you can see, these are mostly days and month names as these are fixed and will not change. In case you extend the selection, keep on dragging and it will repeat and give you the day’s name again.īelow are the custom lists that are already in-built in Excel. Create Your Own Sorting Criteria Using Custom Listsīy default, Excel already has some pre-fed custom lists that you can use to save time.įor example, if you enter ‘Mon’ in one cell ‘Tue’ in an adjacent cell, you can use the fill handle to fill the rest of the days. In this tutorial, I will show you how to create your own custom lists in Excel and how to use these to save time. 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). Month names are quite generic and therefore it’s available by default in Excel.īut what if you have a list of department names (or employee names or product names), and you want to do the same. Excel is smart enough to realize that you want to fill the next month in each cell in which you drag the fill handle. 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. How would you do it? And no, doing it manually is not an option. 
Suppose you have to enter numbers the month names from Jan to Dec in a column. Now, before I get to how to create and use custom lists, let me first explain what’s so great about it. One such useful (and less-known) feature in the Custom Lists in Excel. Excel has some useful features that allow you to save time and be a lot more productive in your day-to-day work.
0 kommentar(er)
