bar viz. ( ) Sort Ascending ( ) Sort Descending. Sort Ascending – Arrange data in alphabetical order (A to Z / Small to Large) Sort Descending – Arrange data in reverse order (Z to A / Large to Small) Field Record Figure . Spreadsheet Data Table Sorting data Step : Place cell pointer in the field (column) to be sorted Step : Click Sort Ascending or Sort Descending icon Chapter OpenOffice Calc, sort the data of selected column and its corresponding values present in other columns are also arranged simultaneously.
Refer Figure . Sort Ascending Sort Descending Figure . Standard Tool Bar with Sort Ascending / Descending Click "Sort Ascending" icon to arrange ascending order Place the Cell pointer anywhere in name column Firgure . Sort Ascending ( ) Multi Sorting Sorting data based on more than one field (column) is known as multi sorting .
For example, the worksheet containing data of students belongs to different groups and classes. To rearrange this data alphabetically by name and group code, multi sorting is used. Refer Figure . .
Chapter Multi-sorting data Step : Select Data → Sort Name are arranged in Ascending order According to names, other data also rearranged 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.
Chapter Select First column in which the data arranged first The selected the second and third column in which the data to be arrange based on the first column Select order of arrangement Fainally Click "Ok" Figure . Multi-sorting dialog box ( ) Sort by selection In Calc sorting