{"id":3920,"date":"2023-02-03T20:16:44","date_gmt":"2023-02-03T20:16:44","guid":{"rendered":"https:\/\/www.bizinfograph.com\/resource\/?p=3920"},"modified":"2024-03-13T15:46:36","modified_gmt":"2024-03-13T15:46:36","slug":"how-to-create-a-custom-list-in-excel","status":"publish","type":"post","link":"https:\/\/www.bizinfograph.com\/resource\/how-to-create-a-custom-list-in-excel\/","title":{"rendered":"How to Create a Custom List in Excel?"},"content":{"rendered":"

Create a Custom List in Excel to transform your data management experience. This feature not only streamlines repetitive tasks and ensures uniformity across your documents but also tailors data analysis to your specific needs. By personalizing your workflow with custom lists, you can enhance productivity, maintain consistency, and visualize data more effectively. Embrace the power of custom lists to make your Excel spreadsheets more efficient and aligned with your unique business or personal objectives.<\/p>\n

This Tutorial Covers:<\/strong><\/p>\n

    \n
  1. The best way to make Excel Custom List<\/strong><\/a><\/li>\n
  2. With your own\u00a0Custom List, you can create your own Sorting Criteria<\/strong><\/a><\/li>\n
  3. How to delete a custom list<\/strong><\/a><\/li>\n
  4. Examples of situations where it can be used<\/strong><\/a><\/li>\n<\/ol>\n

    1. The best way to make Excel Custom List<\/strong><\/h2>\n

    Excel comes with certain pre-fed custom lists by default that you may use to save time.<\/p>\n

    Use the fill handle to fill in the remaining days, for instance, if you type “Sun” in one cell and “Mon” in the one next to it. If you drag to extend the choices, it will repeat and give you the day’s name once more.<\/p>\n

    \"Create<\/p>\n

    The pre-built custom lists for Excel are listed below. As you can see, the names of the days and months are mostly used since they are constant and will not change.<\/p>\n

    \"Create<\/p>\n

    Now, let’s say you want to make a custom list in Excel for a list of departments you frequently use. In this way, you won’t have to dig through old papers the next time you need the names of all the departments in one spot. Simply type the first two in the list and drag them into place.<\/p>\n

    \"Create<\/p>\n

    The steps to make your own Custom List in Excel are listed below:<\/strong><\/p>\n

    Step 1:<\/strong> On the File tab, click.<\/p>\n

    \"Create<\/p>\n

    Step 2:<\/strong> Select \u201cOptions\u201d. This will bring up the dialog box for “Excel Options.”<\/p>\n

    \"Create<\/p>\n

    Step 3:<\/strong> In the left-hand menu, select Advanced. Click the “Edit Custom Lists” button under the General section (you may have to scroll down to get to this option).<\/p>\n

    \"Create<\/p>\n

    Step 4:<\/strong> Import the list by choosing the range of cells that contain it in the Custom Lists dialog box. As an alternative, you can type the name by hand into the List Entries field (separated by comma or each name in a new line). Select Add. You will see that your list has been added to the Custom Lists as soon as you click Add.<\/p>\n

    \"Create<\/p>\n

    As soon as you have the list in Excel’s backend, you may utilize it with Autofill in the same way that you would use numbers or months (as shown below).<\/p>\n

    \"Create<\/p>\n

    While it’s amazing that you can easily drag and drop these custom lists names into Excel, there is something even more awesome that you can do with custom lists (that is what the next part is about).<\/p>\n

    Pro tip:<\/strong> You can also make a named range and utilize it to make the custom list. To do this, click OK after entering the named range’s name in the “Import list from cells” area. The advantage of this is that if you modify or broaden the named range, the custom list will also be instantly modified.<\/p>\n

    2. With your own Custom List, you can create your own Sorting Criteria:<\/strong><\/p>\n

    One amazing feature of custom lists is that you can design your own sorting criteria for them. As an illustration, let’s say you wish to sort a dataset using the criteria High, Medium, and Low.<\/p>\n

    \"Create<\/p>\n

    This is impossible for you to accomplish!<\/p>\n

    The alphabetical order would be messed up if you sorted alphabetically (it will give you High, Low, and Medium and not High, Medium, and Low).<\/p>\n

    Custom Lists truly shine in this situation.<\/p>\n

    You can make your own list of components and use it to arrange the information. The High values will be at the High, followed by the Medium values and the Low values.<\/p>\n

    Using the instructions provided in the previous section, “The best way to make Excel Custom Li<\/strong>st” the first step is to create a custom list (High, Medium, Low).<\/p>\n

    \"Create<\/p>\n

    Following the creation of the custom list excels, you can sort using it by following the instructions below<\/strong><\/h3>\n

    Step 1:<\/strong> Choosing the full collection (including the headers).<\/p>\n

    \"Create<\/p>\n

    Step 2:<\/strong> On the \u201cData\u201d tab, click. Select the \u201cSort\u201d icon from the \u201cSort and Filter\u201d group.<\/p>\n

    The \u201cSort\u201d dialog box will then be displayed.<\/p>\n

    \"Create<\/p>\n

    Step 3:<\/strong> Make the following selections in the \u201cSort\u201d dialog box:<\/p>\n