Click a cell in the source data or table range.
Go to Insert PivotTable. ...
Excel will display the Create PivotTable dialog with your range or table name selected. ...
In the Choose where you want the PivotTable report to be placed section, select New Worksheet, or Existing Worksheet.
Subscribe
#pivotable