Page 29 - Plus_V2.2_C7_Flipbook
P. 29
Sorting data
The selected data will be sorted according to the names in ascending order.
Custom Sorting
In case, more than one columns are to be sorted in such a way that the first column is in ascending
order and if some data is same for more than one rows then the second column of such rows gets
sorted in descending order. You can do this in Excel using Custom Sort. To use Custom Sorting, follow
these steps:
Step 1: Select the range of columns to be sorted.
Step 2: Click on the Sort & Filter command from the Editing group under Home tab. A drop-down list
appears.
Step 3: Click on the Custom Sort option from the drop-down list.
Custom sorting
Advanced Features of Excel 27

