Page 20 - TP_V5.1_C7_fb
P. 20
To use Custom Sorting, follow the steps given below:
2 Click on the Sort & Filter command.
3 Select the Custom
Sort option. A Sort
dialog box will open.
1 Select a column or
range of the data to
be sorted.
4 Click on the Add
Level button to add
another column to sort.
5 Click on Then by
down arrow in the 6 Click on the OK button.
Column section. Select
Name in this case.
Further, more levels can be added to the Sort dialog box for sorting the given data in a spreadsheet.
FILTERING DATA IN EXCEL
The feature of viewing rows of data suiting a specified selection criterion is called filtering data.
Excel allows us to see the important data and hide the rest data temporarily from the set of data.
To apply filters, follow the steps given below:
1 Click on the
Sort & Filter
command.
2 Select the
Filter option.
18 Premium Edition-VII

