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