In Excel for Microsoft 365 on Windows, open the PivotTable field’s drop-down and choose Sort A to Z or Sort Z to A to change the order of its items; the filter checklist follows the field’s item order rather than having a separate sort setting. If those commands are unavailable, sort the field in the PivotTable itself or check whether the field is a report filter, which can behave differently from a row or column field.
What “filter list” means in a PivotTable
People use “filter list” to mean two related things in Excel. It may be the checklist of categories shown when you open a field’s drop-down, or it may mean the labels displayed in the PivotTable after filtering. A field can also sit in the Filters area, above the PivotTable, as a report filter. The place where the field is used matters because Excel offers different sorting controls depending on the layout.
For example, a sales PivotTable might have Region in Rows, Product in Columns, and Year in Filters. The Region and Product fields have labels in the main grid, so you can sort those labels there. Year is a report filter; its drop-down selects a year but does not show row or column labels that you can sort in the same way. In either case, sorting changes the order of items, not which items are selected.
It is also useful to distinguish the filter checklist from a slicer. A slicer is a separate visual control with buttons for categories. Its button order generally reflects the field’s sort order, but it has its own layout and formatting options. A PivotTable field drop-down is not a separate list that you can freely rearrange by dragging checklist entries.
Sort a row or column field alphabetically
For a field in the Rows or Columns area, use the field’s sort command. This sorts the PivotTable items and ordinarily makes the checklist use that order as well. The wording of the drop-down button can vary: it might show the field name, Row Labels, or Column Labels.
- Click the arrow beside the row or column field button in the PivotTable.
- Choose Sort A to Z for ascending order, or Sort Z to A for descending order. For text, ascending means alphabetical; for numbers or dates, it means smallest to largest or earliest to latest.
- Open the field’s drop-down again and check the item list. If the order did not change, select a cell containing one of the field’s labels, right-click it, and choose Sort followed by the desired direction.
You can also use the field’s context menu from a label in the grid. Right-click a category such as East, choose Sort, then choose Sort A to Z or Sort Z to A. This is often the clearest approach when the drop-down button is hard to identify. Sorting a row field rearranges its labels and associated values together; it does not detach a value from its category.
Sort by a measure instead of by the label
Alphabetical order is not always useful. A sales report may be easier to read with the highest-revenue region at the top, or a product list with the largest unit count first. In that case, sort the field by a value in the PivotTable, rather than asking Excel to sort the category names alphabetically.
Right-click a value in the measure column that should determine the order, such as a sales total, and choose Sort followed by Sort Largest to Smallest. Depending on the PivotTable layout, Excel may also offer More Sort Options, where you can specify ascending or descending order and the value field to sort by. Confirm that you selected a number in the intended measure column: sorting by revenue is different from sorting by quantity.
For instance, if the rows are product names and the values are Sum of Sales, a largest-to-smallest sort puts the highest-selling product first. The filter checklist may then reflect the PivotTable’s current item order. This is a ranking, not an alphabetical list, so a reader looking for a product by name may find a different arrangement than expected.
Use a custom or manual order
Sometimes neither alphabetic order nor a value ranking matches the way people work. A report may need months in fiscal-year order, or sales stages in the sequence Prospect, Qualified, Proposal, Won. Excel can retain a manual item order for a PivotTable field. Drag a label to another position in the PivotTable, or use the field’s sorting options where available, then review whether that order is reflected in its filter list.
Manual sorting can be affected by the field’s settings and by refreshing the PivotTable. If Excel keeps restoring an alphabetical order, right-click a field label and inspect Sort or More Sort Options. In the sort options, look for settings that allow manual sorting or specify an ascending or descending sort. The exact controls depend on the PivotTable layout and data source.
Excel also supports custom lists for familiar sequences such as weekdays or months. If the PivotTable uses a custom list, the order may differ from ordinary A-to-Z sorting. Custom lists are useful for recurring business sequences, but they can make an item order surprising to someone who expects alphabetical sorting. If a workbook is shared, document the intended sequence or use an explicit sort field in the source data when the order needs to be consistent and portable.
What to do with a report-filter field
A field in the Filters area appears above the PivotTable as a report filter. Its drop-down is primarily for choosing one or more items, and it may not expose the same sort commands as a row or column field. There is no separate drag-and-drop control for rearranging the entries inside that checklist.
If the report-filter checklist is not in the order you need, first see whether the field is also represented as a row or column field in the PivotTable. Sort the field’s labels there, then check the report-filter list. If the field exists only in the Filters area and its menu has no sort command, try temporarily moving it to Rows, applying the desired sort, and then returning it to Filters. Verify the result after moving it; report-filter behavior can depend on the source and the field’s current sort settings.
When a fixed business sequence must be reliable, a source-data sort key is often a better design than relying on a visually maintained order. For example, add a numeric period number beside a month name and use it to establish the intended sequence. You can keep the helper field in the PivotTable or use it to guide the presentation, depending on the report’s needs. A text month name alone may sort alphabetically, putting April before February.
Refreshes, new items, and source data
A PivotTable is a summary of its source data, so its available filter items come from that data or from its PivotTable cache. If you add a new category to the source, refresh the PivotTable to include it: right-click inside the PivotTable and choose Refresh, or use PivotTable Analyze > Refresh. The new item’s place in the list may follow the existing sort rule, so check whether the field is sorted alphabetically, by value, or manually.
If a deleted category still appears, the PivotTable may be retaining old items in its cache. Select the PivotTable, open PivotTable Analyze > Options (or PivotTable Options, depending on the ribbon display), and inspect the Data settings for the number of items to retain per field. Choosing None and refreshing can remove items no longer present in the source. Be cautious: retained items can be useful when preserving historical selections, and changing retention settings affects the PivotTable’s cached items.
If the PivotTable is based on the Data Model, an external connection, or multiple tables, some traditional sorting and manual-order behavior may differ. In those cases, sorting the source column or creating a deliberate sort-by column in the model may be more dependable than trying to reorder the filter checklist alone.
Why the list may not sort as expected
- The wrong field is being sorted. A PivotTable can have several fields, each with its own item order. Open the drop-down for the field whose checklist you want to change.
- The sort is by value, not label. If the list looks like a ranking, check the field’s sort settings and select an A-to-Z or Z-to-A label sort when that is the goal.
- Labels are stored as different data types. Numbers stored as text, dates stored as text, or inconsistent spaces can produce an order that looks irregular. Clean the source values and refresh.
- A custom list or manual order is active. Excel may intentionally preserve a nonalphabetical sequence. Review the field’s sorting options before changing the source.
- The PivotTable has not been refreshed. A new source category will not necessarily appear until the PivotTable refreshes.
- The report filter has limited sort controls. Try sorting the field as a row field, or use a sort key in the source or data model for a dependable custom sequence.
Do not confuse sorting with filtering: sorting changes the sequence in which items appear, while filtering limits which items are included in the displayed results. Choosing or clearing a checkbox does not alphabetize the list, and selecting Clear Filter does not change its sort order.
Frequently Asked Questions
Can I sort the checkboxes in a PivotTable filter list without changing the PivotTable?
Not as an independent list operation. The checklist is tied to the field’s item order. Sorting that field in the PivotTable is the usual method; report filters may offer fewer controls, so check the field’s sort settings or use a source-data sort key.
How do I sort PivotTable filter items alphabetically?
For a row or column field, open its drop-down and choose Sort A to Z. You can also right-click one of its labels in the PivotTable and use Sort > Sort A to Z. Refresh after changing the source data.
Can I sort a PivotTable filter list by sales or another value?
Yes, when the field is displayed in the PivotTable. Right-click a value in the relevant measure column and choose the largest-to-smallest or smallest-to-largest sort. Check that the selected value belongs to the measure you want to rank by.
Why is my PivotTable filter list not alphabetical?
The field may be sorted by values, manually ordered, or using an Excel custom list. It may also contain inconsistent text or be a report filter with different controls. Inspect the field’s sort options and the source values to identify which applies.
Will new items keep the same sort order after I refresh?
Usually, a normal ascending or descending sort is applied to the refreshed items. A manually maintained order or a custom sequence may need attention when new categories arrive. After refreshing, confirm that new entries appear where the report expects them.
Choosing the best ordering method
Use A-to-Z sorting when readers need to scan for a name, value sorting when the report is meant to rank performance, and manual or custom ordering when the categories have a meaningful sequence. For a one-off PivotTable, the field’s sort menu is usually quickest. For a recurring report with a fixed order, an explicit sort key in the source data or model is easier to maintain and explain.
After changing the order, reopen the filter list and verify the actual sequence, especially if the field is in the Filters area or the PivotTable uses an external source. That final check catches the common mismatch between sorting visible row labels and expecting a separate report-filter checklist to behave identically.
Related
- Excel MIN and MAX Dates: Find the Earliest and Latest
- Excel Merge Shortcut: How to Merge Cells in Microsoft 365
- Excel Merge Shortcut: Keys, Options, and Safer Methods
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Named Ranges in Chart Data: Setup and TroubleshootingYes. In Excel for Microsoft 365 on Windows, you can use a defined name for a chart’s data…
- Excel Waterfall Chart Template: Build and Customize OneYes. In Excel for Microsoft 365 on Windows, select a category-and-value table, then choose Insert > Insert Waterfall,…
- Make Charts in Excel the Same Size: A Step-by-Step GuideTo make several charts the same size in Excel for Microsoft 365 on Windows, select their chart borders…
- Generate an Org Chart in PowerPoint: Steps and TipsTo generate an org chart in PowerPoint for Microsoft 365 on Windows, select Insert > SmartArt > Hierarchy,…
- Create a Bullet Chart in Excel: Step-by-Step GuideTo create a bullet chart in Excel for Microsoft 365 on Windows, make a stacked bar chart for…
- How to Make a Histogram in Excel With Custom BinsTo make a histogram in Excel, select your numeric data, choose Insert > Insert Statistic Chart > Histogram,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.