Excel 简明教程

Data Sorting in Excel 2010

Sorting in MS Excel

在 MS Excel 中对数据进行排序将会根据特定列的内容重新排列行。您可能想要对表格进行排序，以按字母顺序排列名称。或者，您可能想要按从最小到最大或从最大到最小对数据按金额进行排序。

Sorting data in MS Excel rearranges the rows based on the contents of a particular column. You may want to sort a table to put names in alphabetical order. Or, maybe you want to sort data by Amount from smallest to largest or largest to smallest.

要对数据进行排序，请按照以下步骤操作。

To Sort the data follow the steps mentioned below.

  1. Select the Column by which you want to sort data.

  2. Choose Data Tab » Sort Below dialog appears.

sort data

  1. If you want to sort data based on a selected column, Choose Continue with the selection or if you want sorting based on other columns, choose Expand Selection.

  2. You can Sort based on the below Conditions. Values − Alphabetically or numerically. Cell Color − Based on Color of Cell. Font Color − Based on Font color. Cell Icon − Based on Cell Icon.

sorting options

  1. Clicking Ok will sort the data.

sorted records

“排序”选项还可从“主页”选项卡获得。选择“主页”选项卡“排序和筛选”。您可以看到相同的对话框以对记录进行排序。

Sorting option is also available from the Home Tab. Choose Home Tab » Sort & Filter. You can see the same dialog to sort records.

sort home tab