Microsoft Office Tutorials and References
In Depth Information
4. Customizing Excel
44. Click the New Group button at the bottom of the right list box. A New
Group (Custom) item appears after Sort & Filter, as shown in Figure
Figure 4.2. Commands have to be added to a new group.
Commands have to be added to a new group.
55. While the New Group is selected, click the Rename button at the bottom
of the list box. The Rename dialog appears.
66. The Rename dialog offers to let you choose an icon and specify a name
for the group. The icon is only shown when the Excel window is too
small to display the whole group. Choose any icon and type a dis-
play name of Pivot
Pivot. Click OK.
77. The left list box shows the popular commands. You could change Pop-
ular Commands to All Commands and scroll through 2,400 commands.
However, in this case, the commands you want are on the Insert tab.
Choose All Tabs from the top-left drop-down. Expand the Insert tab
and then Tables. Click PivotTable in the left list box. Click the Ad-
d>> button in the center of the dialog to add PivotTable to the new
custom Pivot group on the ribbon. Excel automatically advances to
the next icon of Recommended PivotTables. Click Add>> again.