QQ登錄
微博登錄
微信登錄
高頓網校友情提示，*7山南會計繼續(xù)教育網上總結信息Excel2007新知-Part 5_Excel 12中的排序問題等內容公布如下：
Tables Part 5: Everything you wanted to know about sorting in Excel 1
Tables Part 5: Everything you wanted to know about sorting in Excel 1
表格部分 5: Excel 12中的排序問題
I mentioned in my previous post that the three-condition limit on sorting (Data|Sort) has been removed in Excel 12. As someone correctly pointed out in a comment many posts ago, this means the current sort dialog has changed in Excel 12. Here’s what the new dialog will look like (as always, all the details aren’t finalized, but the key features are clear) if you were in the middle of trying to sort a table by 5 columns:
我在以前的貼中已提到過，在Excel12中去除了排序（數據|排序）的三個條件限制。正如有人在以前的貼中指出的，這意味著在Excel12中，排序對話框改變了。下面就是當試圖在新的對話框對5列進行排序的的樣子（和以往一樣，細節(jié)上沒有最終確定，但主要特點很清晰）。
The dialog is similar in * to the Conditional Formatting Rules Manager discussed in an earlier post. To create sort conditions, users just need to just click on the “Add” button – users can now sort on up to 64 columns – and specify what they want the sort criteria to be. Just like with filters, sorts are smart about data types so we use that information to offer settings that are more descriptive and easier to understand than “ascending” and “descending’. For example, for text columns you will see “A to Z” and “Z to A”, for numeric columns you will see “smallest to largest” and “largest to smallest”, and for date columns you will see “newest to oldest” and “oldest to newest”. Sort conditions can be reordered using the buttons at the top of the dialog. Sort conditions can also be copied to save time. The Options button allows users to specify whether the sort should be case sensitive and allows users to specify the sort orientation (both of these features exist in Excel 2003).
這個對話框的特性和以前討論的條件格式類似。 若創(chuàng)建排序條件，用戶只需點擊“增加”按鈕 – 用戶即可進行64列以上的排序 – 同時指定他們需要的排序標準. 和篩選功能類似，排序可以智能識別數據類型，我們利用此信息來設置比“升序”和“降序”更清晰易懂的排序描述 例如，對于文字列，你會看到 “A 到 Z” 和 “Z 到 A”, 對于數字列，你會看到 “最小到*5” 和 “*5到最小”, 對于日期列，你會看到 “*7到最老” 和 “最老到*7”. 排序條件可以用對話框最上面的按鈕進行重新排列. 排序條件也可以復制以節(jié)省時間. 選擇按鈕允許用戶指定排序是否需區(qū)分大小寫，也允許用戶指定排序方向 (這兩種特點在 Excel 2003中都有).
To see a bit more of the new functionality we have enabled in Excel 12, let’s take a look at another example. Assume I have the following table which contains both manually-applied and conditional formatting (ignore the data – I used RANDBETWEEN() to generate that).
為了更好的理解我們在Excel 12中激活的新功能內容, 讓我們看另外一個例子. 假設下面的表格里包含手工設置的格式和條件格式 (不要在意這些數據 – 我是用RANDBETWEEN()函數生成它們的).
One of the common requests we hear from users is the desire to sort by colour, either manually applied or applied by conditional format. In Excel 12, we bring you exactly that – in addition to cell value, you can sort by
background colour (however applied)
font colour, (however applied)
cell icon (applied via conditional formatting).
For example, I might set up several conditions on the table of data we just looked at …
我們從用戶處得到的一個需求是按照顏色排序, 無論顏色產生于手工設置的格式還是條件格式 在 Excel 12中, 我們帶給您一種新方法 – 除了單元格數值, 你還可以按以下內容排序：
背景顏色 (無論是怎么設置的)
字體顏色 (無論是怎么設置的)
單元圖表 (通過條件格式設置的).
舉例，我可以在表格中的數據上設置幾個條件，我們看 …
and when I press OK, Excel will apply the sort appropriately. Notice the filter buttons again show me the state of each column.
當我點一下OK, Excel 將會恰當的進行排序. 請注意，篩選按鈕將再次顯示每一欄的狀態(tài)
I want to mention two other improvements that we have made that I think certain people will really appreciate. First, we have made it possible to specify a sort order of “Custom List” at every level of sorting. Second, we have made it possible to create a new custom list from within the context of the Sort dialog.
我想提一下我們所做的另外兩個改進，一些用戶會覺得很有益處 首先, 我們實現(xiàn)了在每一層排序都可以特定一個“自定義序列” 第二,從排序對話框里可創(chuàng)建新的自定義序列.
(We have also added the ability to sort by colour or cell icon to our in-grid filter capabilities (nee AutoFilter). Say I started with the following table …
我們也在表格內置的篩選功能（又稱自動篩選）中加入了對顏色或單元格圖標進行排序的能力 我將用下面表格演示 …
掃一掃微信，學習實務技巧
