排序標準

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

評註圖示

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


若要使用此指令...

選擇 [資料] - [排序] - [排序標準] 標籤

在標準列上,按一下

圖示

遞增排序

圖示

遞減排序


排序按照

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.

排序

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

[標準] 工具列上的圖示

圖示

遞增排序

圖示

遞減排序