How do I create a custom list in Excel Import range?
Microsoft Excel has some nice features that prevent extra typing. One familiar feature is using an autofill series for continuous cells. In addition, the spreadsheet program has some built-in lists like months, days of the week, or sequential numbers. In this tutorial, Ill show how to create a custom list in Excel that provides similar functionality. Show Custom Lists vs. Dependent ListsOne question you may want to answer is which type of list do you need. When you think about Excels built-in lists, there are some common denominators. They tend to be used frequently and are known entities. Therefore, you can use them in any workbook. In contrast, there are Excel Dependent Lists, which are conditional. The values you see on that list type are dependent on another value. For example, if you do a lot of reporting by departments, you might want to create a custom list that includes all of them. However, if you needed to do a regional sales commission report, you might make a dependent list that links individual sales reps to a specific region. List Direction Doesnt MatterProbably the first Microsoft Excel feature I valued was allowing the spreadsheet to prefill cells for me. I could type January, grab the fill handle and extend the range to add in the rest of the year. I didnt have to type February, March, and so on. I could do the same thing with days of the week and even omit the weekends. What was equally appealing was I could go horizontal or vertical. This made building a standard report easier. I didnt have to type these cell values or get locked in by spreadsheet orientation, even though I could transpose columns if needed. I also could use these custom lists in any worksheet. How to Create a Custom List in Excel
Now that youve got your list defined, you can start using it. The process is similar to other auto drag options. How to Use Your Custom List
Once you get the hang of creating Excel custom lists, youll start thinking of additional areas where you can use them. Perhaps, youre the commission of a fantasy sports league and need to enter transactions around the same sports teams each week. Or, youre getting a jump on your holiday gift list and need to define friends and family. Regardless of the purpose, Excel custom lists can make data entry faster and consistent. |