Excel Pivot Table Sort Order: How to Change It

Charts & pivot tables · Updated November 19, 2026

To change an Excel PivotTable’s sort order in Microsoft 365 for Windows, right-click a row or column label and choose Sort, then select Sort A to Z or Sort Z to A. To order labels by their summarized numbers instead, right-click a value and choose Sort followed by Sort Smallest to Largest or Sort Largest to Smallest.

How PivotTable sorting works

A PivotTable sorts the items it displays; it does not rearrange the records in the original worksheet table. That distinction matters: sorting a PivotTable’s product names does not sort the source data, and sorting the source data does not necessarily set the order shown in the PivotTable. The report can also have a different sort for each row or column field.

There are two common ways to sort a PivotTable. A label sort arranges field items by their displayed names, such as A to Z or oldest to newest. A value sort arranges those items according to a summary, such as total sales or count of orders. These can produce very different results. For example, a list of sales regions sorted alphabetically might begin with East, while a value sort could put West first because it has the largest total.

Sorting does not change how the values are calculated. It only changes their display order. If the report contains nested row fields, such as Region and then Product, sort the field whose items you want to reorder. Sorting Product changes the order of products within the relevant regions; it does not necessarily rearrange the regions themselves.

Sort row or column labels alphabetically

For a quick label sort in desktop Excel, click or right-click an item in the field you want to sort. Use the label rather than a subtotal or grand total, then choose the direction from the Sort submenu.

  1. Click a cell containing a row or column label, such as a region name or month.
  2. Right-click the cell and point to Sort.
  3. Choose Sort A to Z for ascending text order or Sort Z to A for descending text order. For dates or numbers, Excel may show equivalent oldest-to-newest or smallest-to-largest choices.

You can also use the field’s drop-down arrow in the PivotTable to access sorting options. The exact menu presentation depends on the field and the Excel build, but the goal is the same: apply the sort to the selected PivotTable field. If a selection is ambiguous, click a specific label cell first and use its right-click menu.

Alphabetical sorting treats labels as text. It is useful for names, categories, and codes, but it may not match a meaningful business sequence. A list such as Low, Medium, High is alphabetically ordered as High, Low, Medium, which is not usually the intended progression. Use a custom or manual order for categories with a defined sequence.

Sort labels by summarized values

To rank items by their results, right-click a number in the value column that should determine the ranking. Choose Sort, then select the desired numerical direction. For example, if each row is a sales region and the column contains Sum of Revenue, sorting largest to smallest ranks the regions by revenue.

Choose the value cell carefully. A PivotTable may show several measures, such as Sum of Revenue and Count of Orders. Sorting from a Revenue cell ranks the row labels by revenue; sorting from an Orders cell ranks them by order count. This is a common source of confusion when the order seems wrong: Excel may be sorting correctly, but by a different measure than the one the reader intended.

Another route is to right-click a label in the field to be reordered and choose Sort > More Sort Options. In the sort dialog, select ascending or descending and specify the value field to use. This is useful when you want to make the sort criterion explicit or when the PivotTable has several value fields. Check the selected field and direction before confirming, especially in reports with multiple measures or nested row labels.

Value-based ranking is based on the PivotTable’s current summary and filters. If a report is filtered to show only one year, its ranking reflects that year, not necessarily all years in the source data. Changing a filter or slicer can change the values and, depending on the sort settings, the displayed order. If the rank is intended to represent a particular period or measure, make that choice clear in the report.

Use a manual or custom order

Sometimes neither alphabetic order nor value rank is right. You may need a sequence such as New, In Progress, Review, Complete, or a preferred order for departments. For a one-off arrangement, you can manually move PivotTable items: point to an item’s border until the move pointer appears, then drag it to the desired position. In some layouts, you can also use the right-click menu’s move commands. Move the label, not a value cell.

Manual ordering is convenient for a small report, but it can be harder to maintain when new items appear or the PivotTable is refreshed. For a repeatable sequence, consider a custom list. Excel includes common lists such as weekdays and months, and Windows desktop Excel lets you create additional lists through File > Options > Advanced > General > Edit Custom Lists. In the PivotTable Options dialog, the Totals & Filters tab includes the option to use custom lists when sorting. The option must be enabled for custom-list order to influence the PivotTable sort.

A custom list is useful when the order is stable and reused, such as a standard workflow. If the sequence is specific to one report, manual ordering may be simpler. If it changes frequently or must be shared reliably, adding an explicit sort-order column to the source data and designing the report around that sequence may be easier to manage than relying on a manually rearranged display.

Sort dates, months, and grouped fields

Real date values generally sort chronologically, so oldest to newest is usually the expected choice. A PivotTable can also group dates into years, quarters, or months. When dates are grouped, sort the displayed group field—for example, the Month field—rather than assuming that the underlying day-level dates control every visible label.

Month names stored as text can sort alphabetically, putting April before August and January after December. If Excel recognizes the items as month names, a custom list can give them calendar order. If the labels are not recognized or the source contains inconsistent text, use a reliable date field or add a month number to the source data and use it to support the intended order. A label such as 2026-01 is also more naturally sortable as text than January 2026, provided the format is consistent.

Dates that look like dates but are stored as text can also sort unexpectedly. In the source data, check whether the entries are actual Excel dates and whether their formats are consistent. Correct the source values, refresh the PivotTable, and then sort again if needed. Sorting the displayed labels cannot repair inconsistent source data.

Keep the order sensible after a refresh

A PivotTable refresh recalculates its summaries from the source, and new items may appear. A value sort may place those items according to the updated totals; a manual arrangement may not fit newly added categories. If the report is refreshed regularly, decide whether the desired behavior is a dynamic ranking, a fixed custom sequence, or a manually curated order.

When a sort appears to revert, first apply it again using the intended field and measure. Then check whether the PivotTable has been refreshed, whether a filter changed, and whether a manual order or custom-list setting conflicts with the sort. For a value sort, also verify that the right-hand value field is being used. A refresh is not a reason to sort the source worksheet as a substitute: the PivotTable’s displayed sort is controlled within the report.

For recurring reports, a useful check is to refresh the PivotTable and confirm that the first few items still make sense. If a fixed sequence is essential, document it or encode it in the source data rather than relying on an undocumented drag-and-drop order. That makes the report easier for another person to update and reduces surprises when categories are added.

Common sorting problems

  • The items look alphabetic when you expected a ranking. You probably sorted a label. Right-click a number in the measure you want to rank by, or use More Sort Options and select the appropriate value field.
  • The ranking uses the wrong measure. A report with multiple value columns can be sorted by any one of them. Start from the relevant value cell and confirm the field name in the sort options.
  • Numbers appear in an odd order. If numbers are stored as text, Excel can sort them like words—for example, 100 may appear before 20. Check the source data type, correct it if necessary, refresh, and sort again.
  • Months are alphabetical instead of chronological. Month names may be text labels. Use a recognized month order, a custom list, or a date/month-number field designed for chronological sorting.
  • New items disturb a hand-set sequence. Manual order is less robust when categories change. Use a custom list for a stable sequence or a source-data sort key when the order needs to be maintained over time.

On Excel for Mac and Excel for the web, basic PivotTable sorting is also available, but the menus and dialog placement can differ from Windows desktop Excel. Use the field’s contextual menu or drop-down and look for the same ascending, descending, or value-based choices. The Windows path for managing custom lists through File > Options is specific to Windows; do not expect that exact Options dialog on Mac or in a browser.

Frequently Asked Questions

How do I sort a PivotTable from highest to lowest?

Right-click a value in the measure you want to rank by, choose Sort, then choose Sort Largest to Smallest. This reorders the corresponding row or column items according to that value field.

Can I sort a PivotTable manually?

Yes. In desktop Excel, drag a row or column item to a new position when the move pointer appears, or use the available move commands in its context menu. Manual order may need attention when new items are added or the report is refreshed.

Why does my PivotTable sort months alphabetically?

The month names may be stored or displayed as text, so Excel is treating them as ordinary words. Use a recognized month sequence or a custom list, or sort using a date or month-number field.

Does sorting a PivotTable change my original data?

No. A PivotTable sort changes the order of items in the report, not the order of records in the source worksheet. Sort the source table separately if you also need its rows rearranged.

Why does my PivotTable sort change after I refresh it?

A refresh can update the values, introduce new items, or expose a conflict with a manual order. Reapply the intended sort and check that it uses the right field and measure; use a custom list or source sort key when a fixed sequence must persist.

Related

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.