excel 自定义工具栏_快速自定义Excel工具栏

excel 自定义工具栏

In one of the Excel newsgroups last week, someone asked how they could update several pivot tables at the same time. They were tired of selecting each pivot table separately, and clicking the Refresh button.

在上周的一个Excel新闻组中，有人问他们如何同时更新几个数据透视表。 他们厌倦了分别选择每个数据透视表，然后单击“刷新”按钮。

In an Excel workbook you can refresh all the pivot tables and queries if you click the Refresh All button. That button is on the External Data button, which appears automatically if you click in a cell that's part of an external data range.

在Excel工作簿中，如果您单击全部刷新按钮，则可以刷新所有数据透视表和查询。 该按钮位于“外部数据”按钮上，如果您单击属于外部数据范围的单元格，该按钮将自动显示。

However, if you don't have any external ranges in your workbook, you can add the Refresh All button to the PivotTable toolbar, so it's easy to find and click.

但是，如果您的工作簿中没有任何外部范围，则可以将“全部刷新”按钮添加到“数据透视表”工具栏上，以便轻松查找和单击。

The quickest way to add this button is to click the Toolbar Options button at the end of the PivotTable toolbar. If the toolbar is floating, you'll see a large triangle to the left of the Close button.

添加此按钮的最快方法是单击“数据透视表”工具栏末尾的“工具栏选项”按钮。 如果工具栏是浮动的，您将在“关闭”按钮的左侧看到一个大三角形。

If the toolbar is docked, there's a small triangle in the bar at the end of the toolbar.

如果工具栏已停靠，则工具栏末尾的栏中会出现一个小三角形。

Click the Add or Remove Buttons command, then click PivotTable You'll see a list of all the standard commands that can be added to the PivotTable toolbar.

单击“添加或删除按钮”命令，然后单击“数据透视表”。您将看到可以添加到“数据透视表”工具栏的所有标准命令的列表。

Click on Refresh All, to add it to the toolbar.

单击全部刷新，将其添加到工具栏。

Now, when you want to update all the pivot tables, just click the Refresh All button.

现在，当您要更新所有数据透视表时，只需单击全部刷新按钮。

翻译自: https://contexturesblog.com/archives/2008/10/27/quickly-customize-an-excel-toolbar/

excel 自定义工具栏