Frequently Asked Questions

How to create Pivot Tables?
Last Updated 6 years ago

  • Place the cursor anywhere in the data range, or select the data you want to use in the Pivot Table. On the Insert tab, in the Tables group, click PivotTable, and then click PivotTable again.

  • image
  • The Create PivotTable dialog box opens. The Table/Range box shows the range of the selected data. Select the desired location of the PivotTable – either New Worksheet or Existing Worksheet. Click OK when finished.
  • image
  • The worksheet now shows the layout for the PivotTable. You will also see the PivotTable Field List, which shows the column titles from the source data.
    image

Please Wait!

Please wait... it will take a second!