Sort Criteria

Specify the sorting criteria and sorting direction for the selected range.

Sort Key 1, 2, 3, ...

Select the column or row that you want to use as the primary, secondary or tertiary sort key. Sorting by rows or columns depends on the direction specified in the Sort Options below.

In LibreOffice Calc, the sort dialog initially shows three sort criteria. When the last available sort key is used, the dialog expands to offer an additional sort criterion.

升序/降序排序

Sorts the selection from the highest to the lowest value, or from the lowest to the highest value. Number fields are sorted by size and text fields by the order of the characters. You can define the sort rules on Data - Sort - Options. You define the default on - Languages and Locales - General.

Sort Options

Range contains columns labels

Check to exclude the header row from the sorting range.

Direction

Top to Bottom (Sort Rows)

Sorts rows by the values in the active columns of the selected range.

Left to Right (Sort Columns)

Sorts columns by the values in the active rows of the selected range.