icon to arrange ascending order Place the Cell pointer anywhere in name column Figure . Sort Ascending . . Multi Sorting Sorting data based on more than one field (column) is known as multi sorting .
For example, consider a worksheet containing data of students belonging to different groups and classes. To rearrange this data alphabetically by name and group code, multi sorting is used. Refer Figure . .
Multi-sorting data Step : Select Data → Sort Select First column in which the data arranged first Select order of arrangement Fainally Click "Ok" Figure . Multi-sorting dialog box Step : Sort dialog box appears. (Refer Figure . ).
Step : Select the field name (Student name) in which you want to sort from the “ sort by ” dropdown list box and then choose order of sorting i.e. Ascending or Descending . Ascending is the default selection. Step : Select another field name (Group Code) from the “ Then by ” dropdown list box and choose the order of sorting to this column.
Step : Click “OK” button. In OpenOffice Calc, multi sort can be done only for three fields. Figure . Sorted Table Note: Names are arranged in Ascending order according to names, while the other data are also rearranged simultaneously.
. . Sort by selection In Calc sorting can be done on selected range. But this kind of sorting is generally not recommended, because the other relevant data are also not sorted.
Therefore, OpenOffice Calc displays a warning message for this type of sorting. Refer Figure . . Sorting data by selection: Step : Select any particular field in which you want sort.
Step : Click required Sort icon from standard tool bar or Data → S ort command.Calc displays a “Sort Range” warning message as shown in the Figure . “Sort Range” message box has two options, viz. ( ) Extend selection ( ) Current selection. Step : “Extend Selection” – Sorts the data beyond on the selection.
“Current Selection” – Sort only the selected range of data, remaining data are not sorted. Figure . Sort by selection .