top of page

You are learning PivotTables in MS Excel

How to rearrange fields in a PivotTable?

There are two main ways to rearrange fields in a PivotTable:

1. Using Drag and Drop:

- Click on the field name you want to move.
- Hold down the mouse button and drag the field to the desired new location in the PivotTable layout (Rows, Columns, Values, Filters).
- As you hover over different areas, a green outline will appear to indicate where the field will be placed if you drop it.
- Release the mouse button to drop the field in the new location.

2. Using Right-Click Menu:

- Right-click on the field name you want to move.
- A context menu will appear.
- Depending on the current location of the field, you'll see options like "Move to Rows," "Move to Columns," "Move to Values," or "Move to Filters."
- Select the desired new location from the context menu.
- The field will be rearranged accordingly.

Both methods achieve the same result. Drag and drop is generally faster for simple rearrangements, while the right-click menu might be preferred if you're unsure of the exact destination or want to see all available options.

bottom of page