2014-03-26  作者:ExcelHome  阅读:

译者:rongjun  来源http://blogs.msdn.com/excel

PivotTables part 4: Task-oriented UI, or “improvements the Ribbon affords us”, and some bonus talk about dialogs
数据透视表4:任务向导用户界面,或“为我们提供改进的 Ribbon”,及对话框的一些其它优点。

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.

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).


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.
这个标签用来容纳你在使用数据透视表时的所有常用命令。它给了我们更多的空间来陈列Excel数据透视表已有的全部功能,同样,它还提供了列出Excel 12新增功能的空间。我们在测试中发现:比起以前的Excel版本,所有用户(包括新手及高级用户)能够更广泛地利用Excel的功能。我们很高兴看到这样的改进。

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.

Clicking this button opens a dialog which allows you to easily change either the source data range for PivotTables based on data inside Excel or to change the connection for PivotTables based on external data (which is something we hear customers ask about all the time). An example of this would be switching from a test database to a production database. Here is a screenshot of the dialog illustrating how to change the data source of a PivotTable based on an OLAP data source.

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.

• Clear All. This is a fast, one-click way to remove all fields from the PivotTable and at the same time get rid of any manual formatting, custom captions, etc. that you (or someone else) might have applied. After clicking Clear All, you are at the same state as when the PivotTable was originally created (as if you hadn’t added any fields yet).
• Clear Filters. Clicking this button will remove/reset all filtering applied to any field.

• 清除全部:这是一个快速、一键方式来清除数据透视表中所有字段的方法,同时去除你(或其他人)已经应用的任何手动格式、自定义标题等等。点击清除全部以后,你将回到数据透视表最初创建时的状态(就像你还没有添加任何字段以前)。
• 清除筛选:点击此按钮将移除或重置应用在任何字段的所有筛选。

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.

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 “look” of your PivotTable. Here it is in the beta build.


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.
除了样式展台和布局选项之外(在我原来的文章里讨论过的 previous post),样式标签还有许多控制键,用来方便用户打开或关闭他们的数据透视表某个部分。例如,我们增加了一个合计下拉菜单,可以快速地打开或关闭数据透视表中所有字段的合计(而不是到每一个区域中打开或关闭它,就像目前我们所必须做的那样)。在紧凑和大纲形式下,你也可以控制合计是显示在顶部还是底部。

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.

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.

下文见:Excel2007新知:数据透视表IV——任务向导用户界面,或“为我们提供改进的 Ribbon”及对话框的一些其它优点(二)

Copyright 1999 - 2017 Excel Home.All Rights Reserved.
本站特聘法律顾问:徐怀玉律师 李志群律师   沪ICP备11019229号

沪公网安备 31011702000001号