Tables Part 4_自動(dòng)篩選的改進(jìn)（二）_Excel 2007新知

Tables Part 4_自動(dòng)篩選的改進(jìn)（二）_Excel 2007新知

譯者：lfspecter? 來(lái)源：http://blogs.msdn.com/excel 發(fā)表于：2006年7月7日

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

為了力求功能的完整，excel 12 對(duì)沒有數(shù)字的列也提供了文本篩選功能

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). 顏色篩選不僅支持單元格顏色，也支持字體顏色。另外，也能識(shí)別單元格的條件格式，包括正常格式，斜體填充和條件格式圖標(biāo)設(shè)置。（以前的貼中已提到過）

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. 與顏色篩選一樣，我們同樣可以用顏色進(jìn)行排序，足夠的顏色可以使你基于單元格或背景顏色排序。下一貼中我將舉例演示。

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. 當(dāng)一個(gè)列表處于篩選或排序狀態(tài)時(shí)，Excel 12 使用戶更容易注意到并看出是哪一種篩選或排序。因?yàn)槊恳涣卸加幸粋€(gè)篩選標(biāo)識(shí)，excel 通過改變篩選下拉圖標(biāo)來(lái)指示篩選狀態(tài)。同樣的，通過在被篩選的數(shù)據(jù)列使用的不同的圖標(biāo)，下圖中，你可以指出哪一列被用來(lái)篩選或排列整個(gè)列表。另處你可以移動(dòng)鼠標(biāo)指向圖標(biāo)從而得到更多信息……Excel 將在你鼠標(biāo)所指處顯示篩選排列狀態(tài)。

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. 如上圖所示，取消篩選和排列也只需擊鼠標(biāo)一次即可完成

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. 在結(jié)束前我想提到的最后一件事是我所說的所有功能可以在不涉及列表特性的前提下使用，當(dāng)然和列表結(jié)合后還會(huì)有一定的優(yōu)勢(shì)。雖然工作表只能有一個(gè)自動(dòng)篩選，但是每個(gè)列表都可以有自己的自動(dòng)篩選。 所以當(dāng)你在工作表中需要不止一個(gè)數(shù)據(jù)集時(shí)，列表是你唯一的選擇。與此類似，列表也記憶自己的排序條件，所以如果你需要在整個(gè)工作表中進(jìn)行多重排列時(shí)， 可以借助列表來(lái)實(shí)現(xiàn)。

Next time, more on sorting. 下次，我們將繼續(xù)講解排序

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

版權(quán)聲明：本文內(nèi)容由網(wǎng)絡(luò)用戶投稿，版權(quán)歸原作者所有，本站不擁有其著作權(quán)，亦不承擔(dān)相應(yīng)法律責(zé)任。如果您發(fā)現(xiàn)本站中有涉嫌抄襲或描述失實(shí)的內(nèi)容，請(qǐng)聯(lián)系我們jiasou666@gmail.com 處理，核實(shí)后本網(wǎng)站將在24小時(shí)內(nèi)刪除侵權(quán)內(nèi)容。

版權(quán)聲明：本文內(nèi)容由網(wǎng)絡(luò)用戶投稿，版權(quán)歸原作者所有，本站不擁有其著作權(quán)，亦不承擔(dān)相應(yīng)法律責(zé)任。如果您發(fā)現(xiàn)本站中有涉嫌抄襲或描述失實(shí)的內(nèi)容，請(qǐng)聯(lián)系我們jiasou666@gmail.com 處理，核實(shí)后本網(wǎng)站將在24小時(shí)內(nèi)刪除侵權(quán)內(nèi)容。