Page 35 - iprime_V2.2_class8
P. 35
Using Sort & Filter Command
Step 3 Click Sort A to Z (for text) and Sort Smallest to Largest (for numbers) to sort the data
in ascending order.
The selected data gets arranged in ascending order.
Custom Sort
If you need to sort multiple columns such that the first column is in ascending order and, for
rows with identical data in the first column, the second column is sorted in descending order.
You can do this in Excel using Custom Sort.
To use Custom Sort, follow these steps:
Step 1 Select the range of columns to be sorted.
Step 2 Click on the Sort & Filter command from the Editing group under the Home tab to open a
drop-down list.
Step 3 Click on the Custom Sort option from the drop-down list to open the Sort dialog box.
Step 4 Check My Data Has Headers checkbox if the selected columns have a heading at the top.
Step 5 Click on the Sort By box to open a list of column headers. Select a column head, for
example, ‘Marks Obtained’.
Step 6 Click on the Sort On box to select the Values option.
Step 7 Click on the Order box to select the A to Z option in case of text data and the Smallest
to Largest option for numerical data.
Step 8 Click on the Add Level button at the top of the dialog box. This will add one more row
to define the new criteria.
Step 9 Repeat steps 5 to 7 to add more criteria.
Step 10 Click on the OK button.
The data will be sorted according to the criteria defined.
Clickipedia
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.
If Excel was a magical library, how would you sort books and filter books you
had read?
Spreadsheet—Functions and Charts 33

