Excel 2016 For Dummies
Book image
Explore Book Buy On Amazon

If creating a new pivot table with the Quick Analysis tool in Excel 2016 is too much work for you, you generate them in a snap with the Recommended Pivot Tables command button. To use this method, follow these easy steps:

  1. Select a cell in the data list for which you want to create the new pivot table.

    Provided that your data list has a row of column headings with contiguous rows of data, this can be any cell in the table.

  2. Select the Recommended PivotTables command button on Insert tab of the Ribbon or press Alt+NSP.

    Excel displays a Recommended PivotTables dialog box similar to the one shown. This dialog box contains a list box on the left side that shows samples of all the suggested pivot tables that Excel 2016 can create from the data in your list.

  3. Select the sample of the pivot table you want to create in the list box on the left and then click OK.

    Creating a new pivot table from the sample pivot tables displayed in the Recommended PivotTables di
    Creating a new pivot table from the sample pivot tables displayed in the Recommended PivotTables dialog box.

As soon as you click OK, Excel creates a new pivot table following the selected sample on its own worksheet (Sheet1) inserted in front of the others in your workbook. This pivot table is selected on the new sheet so that the Pivot Table Fields task pane is displayed on the right side of the Excel worksheet window and the PivotTable Tools contextual tab is displayed on the Ribbon. You can use the options on this task pane and contextual tab to then customize your new pivot table.

About This Article

This article is from the book:

About the book author:

Greg Harvey, PhD is the President of Mind Over Media. Greg wrote his first computer book more than twenty years ago and since that time, he has amassed a long list of bestselling titles including Excel All-In-One For Dummies (all editions) and Excel Workbook For Dummies (all editions).

This article can be found in the category: