Back to Pivot Table Menu

Creating a new pivot table


First, make sure the active cell is inside your table of data by clicking somewhere inside the table of data.

Choose the “Insert” tab on the ribbon.

The insert tab on the ribbon.


Click the “PivotTable” button (located at the far left of the ribbon), and then click “OK” in the dialog box that appears.

The insert pivot table button.

A new worksheet has appeared in the workbook, with a special pane at the right hand side.

A new worksheet with the pivot table working environment.

This new worksheet is used to operate the pivot table and all its features.