Select the cells you want to create the PivotTable from
Select Insert>Pivot Table

3. Once you click this, it will create a PivotTable based on an existing table or range

4. Choose the location of PivotTable report to be placed. Select NewWorksheet to have the PivotTable be created in a new worksheet or Existing Worksheet and select the location you want it to appear.
5. Select OK.
6. All done!
Cheers,
Table Originals team

Comments