Page 23 - TP_Prime_V2.2_Class7
P. 23
The Sort dialog box opens.
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 and select the column header according to which you
want to sort the data. In this case, we have selected Client Name header.
Step 6: Click on the Sort On box and select Values option.
Step 7: Click on the Order box and select the A to Z or Z to A option. In this case, we
have selected A to Z option. ADVANCED FEATURES OF EXCEL
Step 8: Click on the Add Level button at the top of the Sort dialog box to add another
column to sort. In this case, we have added Amount Billed column.
Step 9: Click on the OK button.
21
Sort dialog box
The data will be sorted according to the criteria
defined. Soft Hint
To sort data: click Data → Sort
Filtering Data
You must have studied about filtration process which is used to separate unwanted material
from a mixture. Excel also allows you to filter unwanted data from a set of data. To apply
filters, follow these steps:
Step 1: Select the range of columns to be filtered.
Step 2: Click on the Sort & Filter command from Editing group under Home tab. A
drop-down list appears.
Step 3: Click on the Filter option from the drop-down list.
Using Filter

