4.4.4 Sorting Worksheet Data

You can sort individual columns, multiple columns, a range of worksheet data, or an entire worksheet. Origin offers simple sorting as well as nested sorting:

Simple Sorting

In simple sorting, the specified data is sorted using one "sort by" column and a selected sort order.

To perform a simple sort of the selected data:

  1. From the menu, select Worksheet: Sort Columns.
  2. Specify Ascending or Descending from the associated submenu.

If you have highlighted a range of worksheet columns, or a range of values in multiple columns, Origin sorts only the selected data based on the leftmost selected data set and the chosen sort order. If you have highlighted one column, or a range from one column, Origin sorts only the selected data. Note that if you highlight a range of rows, and not the entire column(s), the sort menu command which is enabled will be Worksheet: Sort Range.

To perform a simple sort on the entire worksheet:

  1. Select Worksheet: Sort Worksheet.
  2. Specify Ascending or Descending from the associated submenu.

Origin sorts the entire worksheet based on the leftmost selected column or the leftmost range of selected values in the worksheet and the chosen sort order. If no columns or values are selected, then Origin sorts the entire worksheet based on the leftmost column of the worksheet.

Nested Sorting

To perform a nested sort on the selected data:

  1. Select Worksheet: Sort Columns: Custom.

or

  1. Click the Sort button Button Sort.png on the Worksheet Data toolbar.

To perform a nested sort on the entire worksheet:

  1. Select the entire worksheet and select Worksheet:Sort worksheet:Custom

or

  1. Select the entire worksheet and click the Sort button Button Sort.png on the Worksheet Data toolbar.

The Nested Sort Dialog Box (See Figure)

Sorting Worksheet Data.png

Select the column for the primary sort from the Selected Columns list box and click the Ascending or Descending button. Then select the column for the secondary sort from the Selected Columns list box and click the Ascending or Descending button. Select additional columns as needed.

After clicking OK, Origin sorts the selected data so that the primary column is in ascending or descending order, as specified. If there are multiple rows with the same value in the primary column, the values in the corresponding rows of the secondary column, and the sort order chosen for the secondary column, are used to determine the ordering. This nesting process is continued down to the last column in the Nested Sort Criteria list box.