數(shù)據(jù)透視表IV――任務(wù)向?qū)в脩艚缑妫颉盀槲覀?/h1>

網(wǎng)友投稿 514 2025-04-04

數(shù)據(jù)透視表IV――任務(wù)向?qū)в脩艚缑妫颉盀槲覀?/p>

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

PivotTables part 4: Task-oriented UI, or “improvements the Ribbon affords us”, and some bonus talk about dialogs 數(shù)據(jù)透視表4：任務(wù)向?qū)в脩艚缑妫颉盀槲覀兲峁└倪M(jìn)的 Ribbon”，及對(duì)話框的一些其它優(yōu)點(diǎn)。

As I mentioned a few posts back, one of the key goals for PivotTables in Excel 12 was to use the Ribbon and new dialogs to expose PivotTables’ capabilities to a much broader range of users. Today I want to take a closer look at the new user interface – especially the ribbon – and how we have tried to make commonly-used features and functions much more visible and available with very few clicks of the mouse. I am also going to briefly cover some changes and additions to the PivotTable Options and Field Settings dialogs. 正如我在前面的文章中提到的，Excel12中數(shù)據(jù)透視表的一個(gè)主要目標(biāo)就是通過(guò)使用RIBBON和新的對(duì)話框來(lái)提高性能，使更多的用戶易于使用它。今天我想更進(jìn)一步介紹新的用戶界面——特別是RIBBON——以及我們?nèi)绾问钩Ｓ玫奶匦院凸δ芨菀妆话l(fā)現(xiàn)和利用，并只需點(diǎn)幾下鼠標(biāo)就能實(shí)現(xiàn)。首先，我簡(jiǎn)要的介紹一下數(shù)據(jù)透視表選項(xiàng)和字段設(shè)置對(duì)話框的一些改變和新增功能。

PivotTable tab I – the Options tab When a PivotTable is active (meaning the active cell is inside a PivotTable), you will see two extra PivotTable tabs in the ribbon: Options and Styles. Here is what the PivotTable Options tab looks like in the beta build (note, there is a fair bit not done in this tab, so it is definitely not what you will see in the next beta or when we release Office 12). 數(shù)據(jù)透視表標(biāo)簽I：選項(xiàng)標(biāo)簽 當(dāng)數(shù)據(jù)透視表激活時(shí)（意味著活動(dòng)單元格在數(shù)據(jù)透視表中），在RIBBON上你會(huì)看到兩個(gè)額外的數(shù)據(jù)透視表標(biāo)簽：選項(xiàng)和樣式。如下圖是透視表選項(xiàng)標(biāo)簽在測(cè)試版中所看到的樣子（注：其中有相當(dāng)一部分未完成，所以你在下一個(gè)測(cè)試版或最終版的Office12中看到的會(huì)不一樣）。

This tab is designed to hold all the commands you would commonly use when working with a PivotTable. In addition to giving us more room to expose all the functionality that already exists in Excel PivotTables, it also provides space to advertise new features we have added in Excel 12. In our testing, we have found that it allows all users (both beginning and power users) to take advantage of a wider range of features than in previous versions of Excel. We are pretty excited to see this sort of improvement. 這個(gè)標(biāo)簽用來(lái)容納你在使用數(shù)據(jù)透視表時(shí)的所有常用命令。它給了我們更多的空間來(lái)陳列Excel數(shù)據(jù)透視表已有的全部功能，同樣，它還提供了列出Excel 12新增功能的空間。我們?cè)跍y(cè)試中發(fā)現(xiàn)：比起以前的Excel版本，所有用戶（包括新手及高級(jí)用戶）能夠更廣泛地利用Excel的功能。我們很高興看到這樣的改進(jìn)。

Let’s walk through a few of the interesting “chunks” and controls on the Options tab (I will try and cover others as I put up more posts in the future). The first one I would like to point out is the Change Data Source button. 讓我們來(lái)看看選項(xiàng)標(biāo)簽中一些有意思的“chunks”和控制項(xiàng)（我會(huì)發(fā)表更多的文章介紹其它的命令）。我想指出的第一個(gè)就是“更改數(shù)據(jù)源”按鈕。

Next, let’s take a look at the “Clear” drop down and the “Change Location” button. 下一步，我們看看“清除”下拉菜單和“改變位置”按鈕。

Another thing we hear from PivotTable users all the time is that it is too difficult or slow to clear stuff off of a PivotTable. The Clear drop down provides two new options that hopefully solve those problems. The button applies clear operations to all fields, so users do not need to go to each field individually and remove it or clear the filters applied to it. Specifically, here are what the two options do. 我們從數(shù)據(jù)透視表用戶那里經(jīng)常聽(tīng)說(shuō)的另外煩惱就是清除數(shù)據(jù)透視表中的數(shù)據(jù)太困難或是太慢。這個(gè)清除下拉菜單提供的兩個(gè)新選項(xiàng)可能會(huì)解決這些問(wèn)題。這個(gè)按鈕給所有的字段提供清除操作，所以用戶不必再進(jìn)入每一個(gè)字段來(lái)移除或清除所應(yīng)用的篩選。這兩個(gè)選項(xiàng)的功能如下：

The Change Location button allows you to easily move the active PivotTable to a different location. Selecting this button it brings up a dialog that lets you specify the new location. 改變位置按鈕允許你很容易的把當(dāng)前激活的數(shù)據(jù)透視表移動(dòng)到另外一個(gè)位置，選擇此按鈕將彈出一個(gè)對(duì)話框，允許你指定新的位置。

PivotTable tab I – the Styles tab As mentioned above, there are two PivotTable-specific tabs when a PivotTable is active. The second tab is the Styles tab. The Styles tab is designed to hold all the controls that you need to determine the layout and “l(fā)ook” of your PivotTable. Here it is in the beta build. 數(shù)據(jù)透視表標(biāo)簽I：樣式標(biāo)簽 如上所述，當(dāng)數(shù)據(jù)透視表激活時(shí)有兩個(gè)特殊標(biāo)簽。第二個(gè)就是樣式標(biāo)簽。樣式標(biāo)簽用來(lái)容納決定數(shù)據(jù)透視表的布局及外觀所能用到的所有控制項(xiàng)。以下就是它在測(cè)試版中的樣子：

In addition to the Styles gallery and Layout Options (discussed in my previous post), the Styles tab has a number of controls that are designed to make it easy for users to toggle on and off parts of their PivotTables. For example, we have added a “Subtotals” drop down that makes it very fast to turn on or off subtotals for all fields in the PivotTable (instead of going to every singe field to do it which is what is required today). In Compact and Outline Form, you can also control whether to display the subtotals at the top or at the bottom. 除了樣式展臺(tái)和布局選項(xiàng)之外（在我原來(lái)的文章里討論過(guò)的 previous post），樣式標(biāo)簽還有許多控制鍵，用來(lái)方便用戶打開(kāi)或關(guān)閉他們的數(shù)據(jù)透視表某個(gè)部分。例如，我們?cè)黾恿艘粋€(gè)合計(jì)下拉菜單，可以快速地打開(kāi)或關(guān)閉數(shù)據(jù)透視表中所有字段的合計(jì)（而不是到每一個(gè)區(qū)域中打開(kāi)或關(guān)閉它，就像目前我們所必須做的那樣）。在緊湊和大綱形式下，你也可以控制合計(jì)是顯示在頂部還是底部。

This is another great illustration at how the Ribbon helps usability – we can provide a simple set of results-oriented, visual choices that is scoped to the user’s current activities. We think people will really like this. 這是另外一個(gè)很好的例子，說(shuō)明RIBBON怎樣提供有效地幫助——我們可以提供一套簡(jiǎn)潔的顯示用戶當(dāng)前行為的結(jié)果向?qū)Ш涂梢暬x項(xiàng)、我們認(rèn)為人們會(huì)非常喜歡這個(gè)功能。

Similarly, you can use the Grand Totals drop down to turn on or off grand totals for rows and columns. You can also toggle things like banding on and off for any particular style. 同樣地，你可以用總計(jì)下拉菜單打開(kāi)或關(guān)閉行和列的總計(jì)。你也可以將它做成帶狀或非帶狀的形式，以實(shí)現(xiàn)任何特殊的樣式。

下文見(jiàn)：Excel2007新知：數(shù)據(jù)透視表IV——任務(wù)向?qū)в脩艚缑妫颉盀槲覀兲峁└倪M(jìn)的 Ribbon”及對(duì)話框的一些其它優(yōu)點(diǎn)（二）

版權(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)容。

標(biāo)簽：數(shù)據(jù)

上一篇:數(shù)據(jù)存儲(chǔ)新姿勢(shì)，華為云MySQL混合SSD盤實(shí)例正式發(fā)布~~

下一篇:WPS文件怎么另存為？