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

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

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

In the spirit of completeness, Excel 12 also provides text-based filters for working with non-numeric columns.

为了力求功能的完整，excel 12 对没有数字的列也提供了文本筛选功能

Filter by colour allows you to filter by font colour as well as cell fill colour. In addition, it also recognizes conditional formats on cells including regular formatting, gradient fills, and conditional formatting icon sets (which I discussed in previous posts here and here). 颜色筛选不仅支持单元格颜色，也支持字体颜色。另外，也能识别单元格的条件格式，包括正常格式，斜体填充和条件格式图标设置。（以前的贴中已提到过）

In the same way that we have enabled filtering by colour, we have enabled sorting by colour which, predictably enough, allows you to sort your data based on cell or background colour. I will run through an example of that in the next post. 与颜色筛选一样，我们同样可以用颜色进行排序，足够的颜色可以使你基于单元格或背景颜色排序。下一贴中我将举例演示。

Excel 12 makes it a bit easier to notice when a table has been filtered or sorted as well as easier to figure out what the sort or filter is. For any column that has a filter set, Excel changes the filter dropdown icon to denote its filter state. The same thing happens, although a different icon is used, for columns that have been sorted. In the screenshot below, you can spot which columns were used to sort and filter the table. In addition, you can get more information by hovering the mouse over the icon … Excel will show a tooltop that describes the sort and filter state of the column. 当一个列表处于筛选或排序状态时，Excel 12 使用户更容易注意到并看出是哪一种筛选或排序。因为每一列都有一个筛选标识，excel 通过改变筛选下拉图标来指示筛选状态。同样的，通过在被筛选的数据列使用的不同的图标，下图中，你可以指出哪一列被用来筛选或排列整个列表。另处你可以移动鼠标指向图标从而得到更多信息……Excel 将在你鼠标所指处显示筛选排列状态。

Reapply Command on the Ribbon As you can see from the screenshot above, it also takes a single click to remove all filters from all columns in a table. 如上图所示，取消筛选和排列也只需击鼠标一次即可完成

The last thing I want to mention before closing is that everything I have discussed here can be used without the table feature, however there are certain advantages to using them in conjunction with tables. Each table has its own AutoFilter whereas the sheet can only have a single AutoFilter, so if you need to filter more than one dataset on a sheet, than tables are your only option. Similarly, tables also remember their own sort conditions, so if you need the ability to maintain multiple sort states across a sheet than tables will do the trick. 在结束前我想提到的最后一件事是我所说的所有功能可以在不涉及列表特性的前提下使用，当然和列表结合后还会有一定的优势。虽然工作表只能有一个自动筛选，但是每个列表都可以有自己的自动筛选。 所以当你在工作表中需要不止一个数据集时，列表是你唯一的选择。与此类似，列表也记忆自己的排序条件，所以如果你需要在整个工作表中进行多重排列时， 可以借助列表来实现。

Next time, more on sorting. 下次，我们将继续讲解排序

Published Tuesday, November 01, 2005 3:30 PM by David Gainer

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