Page 22 - Chinmaya_C7_flipbook
P. 22
To sort the data, follow the given steps:
2 Click on the Sort & Filter command.
3 For ascending
order, select the Sort
A to Z option and for
descending order, select
the Sort Z to A option.
1 Select a column
or range of the
data to be sorted.
CUSTOM SORTING
Even when the data is arranged in ascending or descending order, it can still be sorted again within
another column. For example, if Student’s mark list is sorted with respect to Roll No. column, we
can still sort it in the Name column. You can do this in Excel using Custom Sort. To use Custom
Sorting, follow the steps given below:
2 Click on the Sort & Filter command.
3 Select the Custom
Sort option. A Sort
dialog box will open.
1 Select a column or range
of the data to be sorted.
20 Premium Edition-VII

