Page 35 - iPro_trackGPT_V5_Class8
P. 35
use Custom Sort in Excel. A custom sort allows you to sort data in a specific order that you define,
rather than just sorting in ascending or descending order. To use Custom Sort, follow the given
steps:
3 Click on the Sort & Filter command.
2 Click on the
Home tab.
4 Click on
the Custom
Sort option.
1 Select
the range of
columns to
be sorted.
8 Click on the Order box 5 Check My data has
7 Click on the Sort to select A to Z (for text) headers checkbox if the
On box to select Cell and Smallest to Largest selected columns have a
Values option. (for numbers). heading at the top.
9 Click on
the Add Level
button to add a
new criteria.
6 Click on the
Sort by box to
select a column
head for sorting.
10 Repeat steps 6 to 8 11 Click on the OK button.
to specify more criteria.
The data will be sorted according to the criteria defined.
Boost Bits
The sorting can also be done through the Sort & Filter group under the Data tab by
selecting and commands for sorting in ascending and descending order, respectively.
To create a custom sort, click on command.
Spreadsheet—Functions and Charts 33

