Question

Pivot Table button is button is found in tab in MS Excel 2007​

Answer 1

Answer:

Highlight the cell where you'd like to see the pivot table. In this example, we've selected cell A1 on Sheet2. Next, select the Insert tab from the toolbar at the top of the screen. In the Tables group, click on the arrow under the PivotTable button and select PivotTable from the popup menu.

Answer 2

Answer:

click Insert tab

Explanation:

To get the Pivot Table, just click Insert tab, and find out the PivotTable option in Tables group. Microsoft Excel 2007/2010/2013/2016/2019 hide the PivotChart Wizard, which is not shown in the Ribbon.