In a column of a worksheet, type the values you want to sort by in the order you want them, from top to bottom. Steps to create a custom sort list in Excel: The months of the year spelled out starting with Jan. The months of the year abbreviated starting with January. The days of the week spelled out starting with Sun. The days of the week abbreviated starting with Sunday. By default, the custom list in Excel has four custom list shown below. With custom lists, you could sort your worksheet in any way possible. Or create your own custom lists to sort by any other characteristic that doesn’t sort well alphabetically, such as July to June October to September S, M, L, XL. You can sort data by days of the week or months of the year.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |