Say you have the custom list sorted in Column D (range D2:D9) shown below and want to import it and use it for a custom sort.Ģ. Instead of typing custom list items directly into the Custom list window, you could also import a list from a range of cells in the workbook. Click OK to sort the data according to the list.Īs a result, values in Column B are now sorted by the custom list you created. The new custom list of names is selected in the Order drop-down list. As a result, the new list is added to the menu on the left side. In the Custom Lists window, (1) select NEW LIST in the Custom lists menu, and (2) enter names in the order you need (first female from A to Z, then male from A to Z). In the Sort window, in the Order drop-down, choose Custom List, and click OK.ģ. ![]() ![]() Select any cell in Column B (range B2:B9), and in the Ribbon, go to Home > Sort & Filter > Custom Sort.Ģ. Say you have the list of names pictured below in Column B and want to sort first by female and then by male names. There are standard lists – like days and months – but you can also create a custom list for your data. In Excel, you have the option to sort data by custom lists. ![]() In this tutorial, you will learn how to sort with a custom list in Excel.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |