![]() ![]() In the General section, click Edit Custom Lists.For this, we can create a custom sort as follows: For instance, a list of sizes (petite, small, medium, large, and x-large) could be sorted alphabetically, but it wouldn't sort by sizes, from smallest to largest and vice versa. How to use Excel's custom sort featureĮxcel's custom sort feature lets you determine the sort order because some data comes with a sort order that's not alphabetic or numeric-it's sorted by business rules. ![]() None of these advanced options allow you to apply a custom sort order. You probably won't use these advanced options frequently. ![]() You can also add sorting layers to form subgroups. Other advanced sorting options include cell and font color and conditional formatting icons. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |