Page 64 - modular4.0
P. 64
Chapter Profile
Follow the given steps to apply Custom sort option:
2 Click on the Sort & Filter command.
1 Select the range
of columns to be
sorted.
3 Select Custom Sort option.
4 Check My data has headers
8 Click on the Add checkbox, if the selected columns
Level button. have a heading at the top.
7 Click on the Order
drop-down list and
5 Click on the Sort by select the A to Z or Z
drop-down list and select to A option.
the column header.
6 Click on the Sort On drop-down
list and select Cell Values option.
9 Repeat steps 6 to 8 to
add more criteria.
10 Click on the OK button.
Notice that if the Client Name is the same for two different rows in the Client Name column, they
will be sorted based on the Amount Billed column in Largest to Smallest order. This means the client
with the higher amount billed will appear first.
62 Modular (Ver. 4.0)-VII

