Page 29 - TP_Pluse_V2.2_Class_7
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 The moon highlights different aspects
at different times, much like filtering
some data is same for more than one rows then the second focuses on specific data subsets.
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
Step 4: Check My data has headers checkbox, if the selected columns have a heading at the top.
Advanced Features of Excel 27

