LibreOffice 26.2 Help
Specify the sorting options for the selected range.
Select the column that you want to use as the primary sort key.
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 LibreOffice - PreferencesTools - Options - Languages and Locales - General.
Check to exclude the header row from the sorting range.
Sorts rows by the values in the active columns of the selected range.
Sorts columns by the values in the active rows of the selected range.