Part 5_Excel 12中的排序問題（二）_Excel 2007新知

… and I wanted to see all the yellow and red items at the top. I would simply use the sort/filter button to sort first by red …

我想在上面看到所有黃色和紅色項目. 我只簡單的使用排序/篩選按鈕先對紅色進行篩選

… which would group the red values at the top …

它將紅色編為一組顯示在上面

… and I would repeat for the yellow items, which would leave me with a table that was sorted like this.

然后重復操作黃色的項目, 就會出現(xiàn)下面表格中的排序結果

Essentially, what sorting by color does is move all rows that meet the criteria all the to the top. What follows after is not specified – what matters is that rows with a certain format are moved to the top. For convenience sake, we have also added this capability to the context menu in a table or Filtered range. For example, in my table above, I could have just as easily right-clicked on a cell with red fill and selected “Sort by this cell’s fill color” in the “sort and filter” submenu.

實際上，顏色排序所作的就是將所有符合條件標準的行放到最上面. 后面的都是沒有特殊指定的 – 所涉及的就是將指定的格式的行放到上面來. 方便起見, 我們也可以把這個功能增加到表格或已篩選區(qū)域的文本菜單中 例如，在上面的表格里, 我可以簡單的右擊紅色單元格，然后在 “排序與篩選”子菜單選擇 “按照此單元格填充顏色排序”.

(That about wraps up my overview of sort and filter improvements. In my next post I will talk about a new feature that allows easy removal of duplicates from a table of data.

Update to post to clarify sorting by multiple colours concurrently

I want to throw in one more example to illustrate how it is possible to sort on multiple colours at one time. For example, if you had a table with a bunch of formatting on one column and you wanted to sort the table by that formatting …

這些就是我對排序和篩選的改進的總體認識. 在下一篇文章中，我會談及一個新的特性，即輕松刪除數(shù)據(jù)表格中的重復值.

補充一個新方法來解釋負責顏色排序問題

我還想舉一個例子來闡明如何一次對復合顏色進行排序. 例如, 如果你有一個表格，他的一個列里面有多重的格式，而你想對其進行排序

… you would simply bring up the sort dialog and specifiy the order of colours that you wanted to sort by …

你只需要簡單的調(diào)出排序?qū)υ捒虿⒃O定你需要排序的顏色的程序

and press OK. The table would sort by the conditions you specified.

并點擊OK. 表格將根據(jù)你所指定的條件進行排序

I hope that makes sense and clarifies things.

我希望這些功能可以幫助你更好的分析數(shù)據(jù)。

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

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