Related topics
Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

Work with PivotTables

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

Try it!

When you have a large amount of data in Excel, you may want to rearrange the data in your PivotTable to make it easier to work with. You can also add or change the fields in a PivotTable.

  1. Select a cell anywhere in the PivotTable.

  2. Select Analyze > Field List.

  3. In the PivotTable Fields pane, select the fields you want to show in your PivotTable.
    Select the fields for your PivotTable
    Typically, non-numeric fields are added to Rows, numeric fields are added to Values, and Online Analytical Processing (OLAP) date and time hierarchies are added to Columns.

  4. To rearrange fields, drag the fields to the areas you want them to be.

    • Filters are the top-level report filters, above the PivotTable.

    • Columns are shown at the top of the PivotTable.

      Note: Depending on the hierarchy of the fields, columns may be nested inside higher-level columns.

    • Rows are shown on the left side of the PivotTable.

      Note: Depending on the hierarchy of the fields, rows may be nested inside higher-level rows.

    • Values are the summarized numeric values in the PivotTable.

      Note: If you have more than one field in an area, you can rearrange their order by dragging them. To delete a field from the PivotTable, drag the field out of its area. Any changes to the data in the PivotTable do not change the source data.

Want more?

Use the Field List to arrange fields in a PivotTable

Sort data in a PivotTable

Change the data layout of a PivotTable in Excel 2016 for Windows

Work with Relationships in PivotTables

PivotTable Options

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!