Sorting Data in Spreadsheet

How to sort a set of data in OpenOffice Spreadsheet?

Explanation

In Open Office, sort option is used to arrange the selected set of data in ascending or descending order. To sort the data, follow the steps given below,
Step 1: Click on the cell which you want to sort.
Note: When you select a cell, the entire column will be sort on the basis of the character inside in the selected cell.
Step 2: In the home tab, select Data → Sort

Step 3: Sort window opens. Click Sort Criteria tab. Click the drop down under "Sort by" and select the required option. Click Ok to sort the data.
Three columns can be sorted at a time, using the "Sort by, Then by options" either in Ascending or Descending order.

The existing data will be replaced in the sorted order. In the below image, S.NO was sorted in Ascending Order.

To sort the second column, click the drop down under "Then by" and select Name. You can sort the name of the selected column in ascending or descending order.
To sort the third column, click the drop down under "Then by" in the last and select Salary. Select to sort in Descending and Ascending Order and click OK.

In the below image, S.NO, Name and Salary was sorted on the basis of the selected order.

Related Topics