top of page

You are learning PivotTables in MS Excel

How to add rows, columns, and values to a PivotTable?

There are two main ways to add rows, columns, and values to a PivotTable in Excel:

Using the PivotTable Fields Pane:

1. Show the PivotTable Fields Pane: If it's not already visible, you can display the PivotTable Fields pane by clicking on the "Analyze" tab in the ribbon, and then clicking "Show Fields" in the "PivotTable" group.
2. Adding Rows: Drag the field you want to add as rows to the "Rows" area in the PivotTable Fields pane. You can add multiple fields to create a hierarchical row structure.
3. Adding Columns: Drag the field you want to add as columns to the "Columns" area in the PivotTable Fields pane. Similar to rows, you can add multiple fields for further categorization.
4. Adding Values: Drag the field containing the numeric values you want to summarize (e.g., sum, average) to the "Values" area in the PivotTable Fields pane. You can add multiple value fields to display different calculations side-by-side.

Right-Clicking on a Field:

1. Right-click on a field: Select any field already present in your PivotTable by right-clicking on it.
2. Choose placement: From the context menu, select the option that determines where you want to add the field. Options include "Add to Report Filter," "Add to Row Labels," "Add to Column Labels," or "Add to Values."

Additional Tips:

* You can drag and drop fields within the same PivotTable Fields pane area (Rows, Columns, Values) to change their order and organization.
* Right-clicking on a field within the PivotTable itself will also provide similar context menu options for adding or removing that specific field from different areas.
* By experimenting with adding and removing fields in different areas, you can customize your PivotTable to best suit your data analysis needs.

bottom of page