office办公软件入门基础教程In the spirit of completeness, Excel 12 also provides text-based filters for working with non-numeric columns.
为了力求功能的完整，excel 12 对没有数字的列也提供了文本筛选功能
Another feature for date-based columns is that the filter dropdown groups dates by day/month/year rather than displaying a flat list of dates so that it’s easier to drill-down and pick a specific series of dates. If you wanted to select all of the dates in a particular month for instance, you can do so in two clicks.
对日期筛选的另一个特点是在筛选的下拉列中日期是按年月日排列而不是简单的日期的排列，这样，如果要筛选一个特定的日期系列就容易多了。比如，当你想筛选日期列中的某个特定的月时，点击鼠标两次就可以完成了。
In Excel 12, we have gone beyond the ability to filter on values in cells. We now also support the ability to filter by colour color. For example, if I have a table of data I’m working with and I’m using orange and red fill as a way to mark rows that need special attention, I may want to just filter to see everything I have marked red. To set that up is just a few clicks.
在excel12中，我们能做的已超出了对单元格中数值的筛选，现在我们还能通过给单元格涂颜色进行筛选。例如，当我处理一张工作表的数据时，我用桔黄色和红色来填充某些需要特殊关注的行，这样我可以通过筛选来查看所有我标记了红色的内容，几次点击就可完成。
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).
颜色筛选不仅支持单元格颜色，也支持字体颜色。另外，也能识别单元格的条件格式，包括正常格式，斜体填充和条件格式，取消筛选和排列也只需击鼠标一次即可完成
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.
下次，我们将继续讲解排序
