Page 37 - Touchpad_Plus_V3.2_Class 7
P. 37
Multiple Sort
If you want to sort more than one column in such a way that the first column is in ascending
order and if some data is same for more than one rows then the second column of such rows
gets sorted in descending order. You can do this in Calc using Sort option of Data menu.
Perform the following steps to sort multiple columns:
Step 1 Select the range of columns to be sorted.
Step 2 Select the Sort option from Data menu. The
Sort dialog box will open.
Step 3 Check the Range contains column labels
checkbox if your data includes column labels,
so the header row is not included in the sort.
Step 4 In the Sort Key 1 section, click on the Column
drop-down list to view the list of column
headers under the Sort Criteria tab. Select a
column header, for example, ‘Department.’
Step 5 Click on the Ascending radio button for Sort
Key 1. Using Data menu
Step 6 Repeat steps 4 and 5 to sort ‘First Name’ column in descending order under
Sort Key 2.
Step 7 Click on the OK button. The data will be sorted according to the criteria defined.
Unsorted data Sorted data
Clickipedia
The sorting can also be done through Standard toolbar by selecting Sort Ascending or
Sort Descending tools for sorting in ascending and descending order respectively. To
sort multiple columns, click on the Sort tool .
FILTERING DATA
You must have studied about filtration process which is used to separate unwanted material
from a mixture. Calc also provides you to filter unwanted data from a set of data. Perform the
following steps to apply AutoFilter:
Step 1 Select the range of columns to be filtered.
More on Calc 35

