高頓網(wǎng)校友情提示，*7楚雄彝族自治州會(huì)計(jì)繼續(xù)教育網(wǎng)上總結(jié)信息Excel2007新知-Part 5_Excel 12中的排序問題等內(nèi)容公布如下：
　　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 …
　　我想在上面看到所有黃色和紅色項(xiàng)目. 我只簡(jiǎn)單的使用排序/篩選按鈕先對(duì)紅色進(jìn)行篩選
　　… 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.
　　然后重復(fù)操作黃色的項(xiàng)目, 就會(huì)出現(xiàn)下面表格中的排序結(jié)果
　　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.
　　實(shí)際上，顏色排序所作的就是將所有符合條件標(biāo)準(zhǔn)的行放到最上面. 后面的都是沒有特殊指定的 – 所涉及的就是將指定的格式的行放到上面來. 方便起見, 我們也可以把這個(gè)功能增加到表格或已篩選區(qū)域的文本菜單中 例如，在上面的表格里, 我可以簡(jiǎn)單的右擊紅色單元格，然后在 “排序與篩選”子菜單選擇 “按照此單元格填充顏色排序”。
　　(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 ...
　　這些就是我對(duì)排序和篩選的改進(jìn)的總體認(rèn)識(shí). 在下一篇文章中，我會(huì)談及一個(gè)新的特性，即輕松刪除數(shù)據(jù)表格中的重復(fù)值.
　　補(bǔ)充一個(gè)新方法來解釋負(fù)責(zé)顏色排序問題
　　我還想舉一個(gè)例子來闡明如何一次對(duì)復(fù)合顏色進(jìn)行排序. 例如, 如果你有一個(gè)表格，他的一個(gè)列里面有多重的格式，而你想對(duì)其進(jìn)行排序
　　... you would simply bring up the sort dialog and specifiy the order of colours that you wanted to sort by ...
　　你只需要簡(jiǎn)單的調(diào)出排序?qū)υ捒虿⒃O(shè)定你需要排序的顏色的程序
　　and press OK. The table would sort by the conditions you specified.
　　并點(diǎn)擊OK. 表格將根據(jù)你所指定的條件進(jìn)行排序
　　I hope that makes sense and clarifies things.
　　我希望這些功能可以幫助你更好的分析數(shù)據(jù)。
 　　　　
　　掃一掃微信，學(xué)習(xí)實(shí)務(wù)技巧
　　　
　　高頓網(wǎng)校特別提醒：已經(jīng)報(bào)名2014年財(cái)會(huì)考試的考生可按照復(fù)習(xí)計(jì)劃有效進(jìn)行！另外，高頓網(wǎng)校2014年財(cái)會(huì)考試高清課程已經(jīng)開通，通過針對(duì)性地講解、訓(xùn)練、答疑、?？?，對(duì)學(xué)習(xí)過程進(jìn)行全程跟蹤、分析、指導(dǎo)，可以幫助考生全面提升備考效果。