Can I Sort Data Using Custom List. Region LSE North South 0 Cn 33330367 9178917 1 Develd -36157025 -27669988 2. Note that the abbreviated days and months do not have periods after them.
Select the data and click on Sort available in Data tab. For example your company may have several stores and you want the stores to be listed in a particular order not alphabetically. In the Sort dialog box under Column in the Sort by or Then by box select the column that you want to sort by a custom list.
Excel has several built-in Custom Lists Days of the Week and Months of the Year.
For example in this worksheet we have a list of opportunities and we want to sort the list in the order that stages appear in column H. How to sort data by custom list in Excel. If you use periods for these abbreviations they are not recognized and are not sorted correctly. For the best results each column should have a heading.
