Page 46 - Computer Genius Class 06
P. 46
Custom Sort
more than one column is to e sorted in such a ay that the first column is in ascending order and
i some data is the same or more than one ro then the second column o such ro s gets sorted in
descending order. You can do this in Excel using Custom Sort.
To use ustom ort ollo the gi en steps
2 lic on Home tab. 3 lic on the Sort & Filter command.
4 lic on
the Custom
Sort option.
1 elect the range o columns to
be sorted.
9 lic on the Add 8 lic on the Order box to select
Level utton to de ine 7 lic on the Sort On box A to Z or te t and Smallest to
a new criteria. to select Cell Values option. Largest or num ers .
5 hec My
data has
6 lic on headers
the Sort by chec o i
box to select the selected
a column columns
head or have a
sorting. heading at
the top.
10 epeat steps to to sort ar s in 11 lic on the OK button.
previous term column in descending order.
The data ill e sorted according to the criteria defined.
44 Computer Genius-VI

