Tables Part 4:自动筛选的改进（一）_Excel 2007新知

Tables Part 4:自动筛选的改进（一）_Excel 2007新知

译者：lfspecter  来源：http://blogs.msdn.com/excel 发表于：2006年7月7日

Tables Part 4: AutoFilter improvements: much more than just multi-select … 自动筛选的改进：远远不仅是多项选择

Sorting and filtering are two of the most important types of basic analysis that you can do with data. In Excel 12, we have improved sort and filter functionality to better expose common tasks, to make key tasks simple, and to enable scenarios that were not possible in earlier versions. We have done work in AutoFilter, our sort functionality (Data|Sort), and in PivotTables. I will cover the first two (AutoFilter and Sort) in posts this week and PivotTables in a few weeks when I review all our PivotTable work. Today, I will focus on AutoFilter. 排序与筛选是分析数据的最基本的两种方式， 在EXEL12 中， 我们的改进使选择与筛选的功能更加强大，普通任务一目了然，关键任务更加简单，使以前版本中不可能的场景成为可能。 我们还在自动筛选，排序功能（数据排序），数据透视表方面做了改进。我将在本周发贴谈到前两个问题（自动筛选与排序），数据透视表将在几周后我收到我们所有的资料后谈到。今天，我将主要谈一谈自动筛选。

Several of our goals for AutoFilter were driven by a couple of our top customer requests. Specifically, in Excel 12 we have 为了满足客户的最主要的一些需求，自动筛选功能，特别是在EXEL12中，设定了以下几个目标：

• Enabled multi-select in AutoFilter, so you can select any number of items for your filter condition • Added the ability to sort and filter by colour • Increased the limit of items in the AutoFilter dropdown from 1,000 items to 10,000 items • 允许在自动筛选中多项选择，这样你可以在筛选条件里任意选择所需的项目。 • 增加排序与筛选颜色的功能。 • 把自动筛选下拉菜单中最多显示1000项增加到10000项。

• Additionally, we have • Added a “quick filter” feature that enables data-type-specific filtering • Added date grouping to date AutoFilters • Made it possible to re-apply a set of filters with one button click • Provided more UI to help users figure out what filters are applied to a range/table 另外： • 增加一个“快速筛选”功能，可以按指定数据类别来筛选。 • 自动筛选中增加了数据分组功能 • 单击一次即可重新筛选。 • 提供更多的界面以帮助用户识别当前区域或工作薄使用的筛选方式。

Let’s take a closer look. The first thing we tried to do was to make it easier to turn on AutoFilter by making it part of the “Sort & Filter” commands on the Sheet tab in the Excel ribbon (the tab that is shown by default). 现在让我们来详细了解一下。我们尝试做的第一件事就是让自动筛选功能成为工具栏按钮中“排序筛选”命令的一部分。

Sort options remain at the top of the dropdown, but we have updated the text to reflect the data being filtered (“smallest to largest” for numbers, “oldest to newest” for dates, etc.). We have added the ability to sort by colour (more on that later). We’ve added a way to quickly and easily remove all filter conditions from a single column. Below that we have some filter options (more on that in a moment) and finally we have the filter items themselves. 排序选项仍然在下拉菜单的最上部，但是更新了文本来说明被筛选的数据（最小到最大用于数值，最早到最新用于日期）我们增加了对颜色的排序功能（稍后介绍更多）。我们还提供了在单列中快捷取消筛选的方法。其下方有一些关于筛选的选项（稍后马上介绍），最后面是筛选项目本身。

Let’s look at filtering in more detail, starting with multi-select. In previous versions of Excel, if you wanted to multiple-select items, you needed to use the Custom dialog, and that limited you to two choices. In Excel 12, you can simply select the items you want to see included in your filter and press OK. This is much faster, easier to discover, and supports as many items as you want. 让我们先从多项选择开始来更多的了解一下筛选功能。在早期的Excel版本里，如果你想要进行多项选择，你必须使用自定义对话框，而且你只能有两个选择。但在Excel 12里，你可以轻松的选择你想要的筛选项目，然后按OK即可。现在可以更加便捷的查找你想要的任何项目。

As you can see from the picture above, Excel offers an array of date filters that make filtering by different date ranges a snap. What makes these filters special is that they are based on the system clock so my “last month” filter will always filter to the previous month when the filter is reapplied. Setting up these types of dynamic filters were not easily possible in previous versions. 从上图可以看出，Excel提供了一系列日期选项来筛选不同日期区域的数据。这些筛选选项的特殊之处就在于它们是以系统时间为基础的，所以当我们选取“上个月”时，筛选的总是筛选功能运行时的上个月。在较早的版本中对动态筛选的设置还比较困难。

We have also added “quick filters” for numeric data. For example, after I filter by date, I can then filter my profit column to only show me sales that were above average. 我们还对数据的筛选增加了快速筛选功能，例如，当我按日期筛选完成后，我还可以对“利润”这一列进行筛选，只显示那些大于平均值的的项。

版权声明：本文内容由网络用户投稿，版权归原作者所有，本站不拥有其著作权，亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容，请联系我们jiasou666@gmail.com 处理，核实后本网站将在24小时内删除侵权内容。