Please note that other Pearson websites and online products and services have their own separate privacy policies. This privacy notice provides an overview of our commitment to privacy and describes how we collect, protect, use and share personal information collected through this site. Pearson Education, Inc., 221 River Street, Hoboken, New Jersey 07030, (Pearson) presents this site to provide information about products and services that can be purchased through this site. At this point, the right side of the dialog should look like Figure 3.3. This is the obscure entry point to create Multiple Consolidation Range pivot tables. Scroll through the left list box until you find PivotTable and PivotChart Wizard. The left list box changes to show an alphabetical list of all commands.

In the drop-down above the left list box, select All Commands.

Excel automatically advances to the next icon of Recommended PivotTables. Click the Add button in the center of the dialog to add PivotTable to the new custom Pivot group on the ribbon. Expand the Insert tab, and then expand Tables. Choose All Tabs from the top-left drop-down. However, in this case, the commands you want are on the Insert tab. You could change Popular Commands to All Commands and scroll through 2,400 commands.

The left list box shows the popular commands.

Choose any icon and type a display name of Pivot. The icon is shown only when the Excel window is too small to display the whole group.

The Rename dialog offers to let you choose an icon and specify a name for the group.

While the New Group is selected, click the Rename button at the bottom of the list box.Figure 3.2 Commands have to be added to a new group.

Excel for mac 2016 customize ribon