Excel 简明教程

Data Filtering in Excel 2010

Filters in MS Excel

在 MS Excel 中筛选数据是指仅显示满足特定条件的行。（其他行将被隐藏。）

Filtering data in MS Excel refers to displaying only the rows that meet certain conditions. (The other rows gets hidden.)

使用存储数据，如果您有兴趣查看鞋码为 36 的数据，则可以设置过滤器来执行此操作。按照以下提到的步骤操作。

Using the store data, if you are interested in seeing data where Shoe Size is 36, then you can set filter to do this. Follow the below mentioned steps to do this.

  1. Place a cursor on the Header Row.

  2. Choose Data Tab » Filter to set filter.

set filter

  1. Click the drop-down arrow in the Area Row Header and remove the check mark from Select All, which unselects everything.

  2. Then select the check mark for Size 36 which will filter the data and displays data of Shoe Size 36.

  3. Some of the row numbers are missing; these rows contain the filtered (hidden) data.

  4. There is drop-down arrow in the Area column now shows a different graphic — an icon that indicates the column is filtered.

applied filter

Using Multiple Filters

您可以按多个条件（例如按多个列值）过滤记录。假设在对尺码 36 过滤后，您需要设置一个颜色等于咖啡的过滤器。设置完鞋码的过滤器后，选择“颜色”列，然后设置颜色的过滤器。

You can filter the records by multiple conditions i.e. by multiple column values. Suppose after size 36 is filtered, you need to have the filter where color is equal to Coffee. After setting filter for Shoe Size, choose Color column and then set filter for color.

multiple filter