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.
下次，我們將繼續講解排序
