排序標準

指定用於所選區域的排序選項。

評註圖示

確保選取了列或欄的標題。


若要使用此指令...

Choose Data - Sort - Sort Criteria tab.

On Standard bar, click

圖示

遞增排序

圖示

遞減排序


排序按照

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 - Language Settings - Languages.

向下

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 - Language Settings - Languages.

然後按照

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 - Language settings - Languages.

向下

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 - Language settings - Languages.

排序

將選取範圍從最高值排序到最低值,或是從最低值排序到最高值。數字欄位會依大小排序而文字欄位會以字元順序排序。您可以在 [資料] - [排序] - [選項] 上定義排序規則。您可以在 - [語言設定] - [語言] 上定義預設值。

[標準] 工具列上的圖示

圖示

遞增排序

圖示

遞減排序