Sort Criteria

Specify the sorting options for the selected range.

note

Ensure that you include any row and column titles in the selection.


To access this command...

Choose Data - Sort - Sort Criteria tab.

On Standard bar, click

Icon Sort Ascending

ркЪрквркдрк╛ ркХрлНрк░ркоркорк╛ркВ ркЧрлЛркарк╡рлЛ

Icon Sort Descending

ркЙркдрк░ркдрк╛ ркХрлНрк░ркоркорк╛ркВ ркЧрлЛркарк╡рлЛ


рк╡ркбрлЗ ркХрлНрк░ркоркмркзрлНркз ркХрк░рлЛ

Select the column that you want to use as the primary sort key.

ркЪркбркдрк╛ркХрлНрк░ркоркорк╛ркВ

Sorts the selection from the lowest value to the highest value. The sorting rules are given by the locale. You can define the sort rules on Data - Sort - Options. You define the default on - Languages and Locales - General.

ркЙркдрк░ркдрк╛ркХрлНрк░ркоркорк╛ркВ

Sorts the selection from the highest value to the lowest value. You can define the sort rules on Data - Sort - Options. You define the default on - Languages and Locales - General.

Then by

Select the column that you want to use as the secondary sort key.

ркЪркбркдрк╛ркХрлНрк░ркоркорк╛ркВ

Sorts the selection from the lowest value to the highest value. You can define the sort rules on Data - Sort - Options. You define the default on - Languages and Locales - General.

ркЙркдрк░ркдрк╛ркХрлНрк░ркоркорк╛ркВ

Sorts the selection from the highest value to the lowest value. You can define the sort rules on Data - Sort - Options. You define the default on - Languages and Locales - General.

Sort Ascending/Descending

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.

Icons on the Standard toolbar

Icon Sort Ascending

ркЪрквркдрк╛ ркХрлНрк░ркоркорк╛ркВ ркЧрлЛркарк╡рлЛ

Icon Sort Descending

ркЙркдрк░ркдрк╛ ркХрлНрк░ркоркорк╛ркВ ркЧрлЛркарк╡рлЛ

Please support us!