You will find your list added in the Custom lists section. Then in the List entries section, write down the names of your custom entries, separated by comma (,), following your desired sort order.įor the sake of this example, write A+, A, A-, B, C, F.Under the section Custom lists, you will find all the default sorting lists like Sun, Mon, Tue, Wed, Thu, Fri. You will get the Custom Sort dialogue box.Under the General section, you will find a button called Edit Custom Lists. You will get a new window called Excel Options. To create a sorted list of this sequence, first, go to File>Options from Excel Toolbar.Writing Directly in the Custom Lists Dialogue Box That means the sorting sequence will be: A+, A, A-, B, C, F.ġ. Our objective today is to sort the students according to their grades, from A+ to F. To highlight them further, I have given them six different colors, from dark to light. Here we have a data set with the Names, Marks in Mathematics, and Grades of some students of a school called Sunflower Kindergarten. How to Create and Use Custom Sort in Excel.xlsx
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |