top of page

Creating a PivotTable

  1. Select the cells you want to create the PivotTable from

  2. 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!


Table Originals team


bottom of page