Excel Pivot Table Order Columns: Sort and Rearrange

In Excel for Microsoft 365 on Windows, reorder PivotTable columns by dragging fields within the Columns area of the PivotTable Fields pane; to reorder the labels inside a column field, sort them or use manual item ordering. These are different operations, so first decide whether you mean changing the arrangement of fields, changing the sequence of labels, or moving value columns.

What “order columns” can mean in a PivotTable

A PivotTable can have several kinds of column order. If you have fields such as Region and Product in the Columns area, their position determines which field groups the columns and which field appears as a subdivision. If the column headings are product names, their order might instead mean alphabetical order, a custom sequence, or an order based on sales. Finally, if the PivotTable displays several measures, such as Sum of Sales and Count of Orders, you may want to rearrange those value columns.

For example, a report might show North and South as the main column groups, with product names under each. Moving Region and Product in the field layout changes the grouping. Moving the individual product labels changes their sequence within the layout. Sorting by sales changes the sequence according to the numbers. Knowing which change you want prevents an otherwise confusing adjustment.

Rearrange fields in the Columns area

To change which fields make up the columns, click anywhere in the PivotTable. On the ribbon, choose PivotTable Analyze > Field List if the field pane is not visible. In the pane, look at the four layout boxes: Filters, Columns, Rows, and Values.

Find the field you want to move in the field list or in the Columns box.
Drag it into the Columns box if it is not already there.
To change the nesting order, drag it above or below the other fields in that box.
Check the PivotTable headings. If the result is not what you intended, drag the field back or move it to Rows instead.

The first field in Columns is generally the outer grouping, while the next field creates subdivisions within it. For instance, placing Region above Product gives you region groups with product labels beneath each group. Reversing them puts products at the outer level and regions within each product. A field can also be removed from the column layout by dragging it out of the box, or by clearing its field-list checkbox; be careful, because clearing it removes it from the PivotTable rather than merely moving it to Rows.

Move individual column labels into a custom order

If the fields are in the right places but their displayed items need a particular sequence, use manual sorting. This is useful for a sequence such as High, Medium, Low, or for a presentation order that does not follow the alphabet. Click a label in the PivotTable and drag it to its intended position. When dragging is available, Excel shows a placement indicator; release the item when it is where you want it.

You can also right-click an item and look for Move options, such as moving it up, down, to the beginning, or to the end. The available commands depend on the PivotTable and the selected item. If manual movement seems unavailable, check the field’s sorting setting: right-click one of its labels, choose Sort > More Sort Options, and select the manual option if it is offered. Automatic ascending or descending sorting can put labels back into that order instead of preserving your intended sequence.

Manual ordering is most appropriate when the sequence has meaning beyond its spelling. If you use it for a recurring report, make the order understandable to readers—for example, put the preferred sequence in a note or use clear labels. A new item added to the source data may not land exactly where you expect, so review the order after refreshing.

Sort column labels alphabetically

For an ordinary A-to-Z or Z-to-A order, right-click a label in the field you want to sort, then choose Sort > Sort A to Z or Sort > Sort Z to A. You can also use the sort commands available from a field’s drop-down menu. Apply the sort to the correct field: in a nested layout, sorting Product is different from sorting Region, even though both appear among the column headings.

Text labels are sorted as text, not according to any business meaning you may associate with them. For example, a text list containing Jan, Feb, and Mar may sort alphabetically rather than in calendar order. Similarly, labels such as Item 1, Item 2, and Item 10 can appear in an order that reflects text sorting rather than the numerical part of the name. Use a date field, an appropriate numeric field, or a deliberate manual order when a simple alphabetic sort is not suitable.

Sort column groups by their values

To put column items in order by a measure such as sales, select a numeric value in the relevant part of the PivotTable, right-click, and choose a largest-to-smallest or smallest-to-largest sort command. This sorts the associated items by the selected measure rather than by their names. For example, if Product names are the column items and Sum of Sales is the measure, sorting by that measure can place the highest-selling products first.

Check the outcome carefully when the PivotTable has multiple fields or measures. A sort applies to a particular field and may be interpreted within its parent group; it does not necessarily create one global ranking across every group. For more control, right-click a label, choose Sort > More Sort Options, and specify the sort direction and the value field to use when those choices are available. If the result looks wrong, undo the sort or choose a different value cell so Excel has the intended measure as its sorting basis.

Reorder multiple value columns

When a PivotTable contains more than one measure, Excel often displays a special ∑ Values field in the Columns area. The measure headings might read Sum of Sales, Count of Orders, and Average of Margin. To change their order, find the Values list in the PivotTable Fields pane and drag the measures up or down. You can also reposition the ∑ Values field between Columns and Rows if you want the measures arranged vertically instead of horizontally.

This is separate from rearranging ordinary source fields. Moving Product in the Columns box changes the product grouping; moving Sum of Sales in the Values list changes which measure appears first. If you cannot see ∑ Values, the PivotTable may contain only one measure, or the values may be displayed on the other axis. Add another field to Values or inspect the layout boxes before assuming that the measures have disappeared.

Keep dates and business sequences in the intended order

Date headings usually behave best when the source column contains genuine Excel dates rather than text that merely looks like dates. A real date field can be sorted chronologically and may be grouped into years, quarters, or months. If month names were imported as text, Excel may sort them alphabetically. Correcting the source data to use dates, then refreshing the PivotTable, is generally more reliable than repeatedly dragging month labels into place.

For non-date sequences—such as Bronze, Silver, Gold, or workflow stages—alphabetical sorting may be logically wrong. Manual ordering is one option. Another is to keep a ranking or sequence field in the source data and use it to organize the report. This makes the intended order easier to maintain when new records arrive, although the helper field may need to be included in the PivotTable layout or used as part of the report design.

Why the order changes or will not move

The wrong thing is selected: Dragging a field in the pane changes the layout; dragging a label in the table changes item order. Click a visible label when you mean to sort items.
An automatic sort is active: A-to-Z or value-based sorting can override a manual sequence. Use More Sort Options and choose manual sorting if available.
The source uses text instead of dates or numbers: Text can sort alphabetically even when it represents months or numbered categories. Fix the source type and refresh.
The PivotTable has nested fields: A sort may apply inside each outer group rather than across the entire report. Confirm which field and level you are sorting.
The PivotTable comes from an external or OLAP source: Some connected PivotTables restrict manual ordering or offer different sorting choices. The source system or connection may control which operations are available.

Also remember that sorting the worksheet’s source data is not a dependable way to set the PivotTable’s displayed order. A PivotTable organizes items using its own field and sort settings. After changing source records, use PivotTable Analyze > Refresh to update the report, then verify that manual positions and newly added labels still meet your needs.

Frequently Asked Questions

How do I change the order of columns in an Excel PivotTable?
Open the PivotTable Fields pane and drag fields within the Columns area. This changes the grouping and nesting of fields, not necessarily the order of individual labels.

How do I sort PivotTable columns from largest to smallest?
Right-click a value associated with the column items and choose the largest-to-smallest sort command. If there are multiple measures or nested fields, confirm that Excel is sorting the intended field by the intended value.

Can I put PivotTable column labels in a custom order?
Yes. Drag labels into position or use the field’s manual Move options when available. If Excel keeps restoring an automatic order, change the field’s sort setting to manual.

Why are month names sorted alphabetically in my PivotTable?
The source may contain month names as text rather than actual dates. Use real date values for chronological sorting, or create a deliberate manual or ranking-based sequence for text categories.

Will refreshing a PivotTable reset my column order?
Refresh updates the PivotTable from its source, and manually arranged items are often retained. However, new labels and automatic sort settings can affect the result, so check the order after refreshing.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.