Page 76 - IT-802_class_12
P. 76
3.7.2 Multiple Sorting
Sorting can be applied with multiple columns criteria, where each criterion is applied one after the other. Sorting data
that is based on more than one field (column) is known as multiple sorting.
For example, if the worksheet contains the data of 30 students belonging to different groups and classes, multiple
sorting can be applied to rearrange this data with the names and group codes in alphabetical order.
Consider a sheet with three columns, viz., S. No., States, and Capital. For multiple sorting, perform the following steps:
1 Click on the Sort from the Data menu. The Sort dialog box appears.
2 From the Sort by option in the drop-down list box, select the field name (here, States of India) in which we have
to apply the sorting.
3 Click to select the sorting order, i.e., Descending. (Though the default setting is Ascending.)
1
2
3
4 From the Then by option in the drop-down list box, choose another field name (here, Capital) and the sort order
for this column by clicking on Ascending.
4
5 From the next Then by option in the drop-down list box, choose another field name (S. No.) and the sort order
for this column by clicking on Ascending.
74 Touchpad Information Technology-XII

