Excel Pivot Table: Filter and Sort Alphabetically

Charts & pivot tables · Updated November 19, 2026

Yes. In Excel for Microsoft 365 on Windows, click a PivotTable row or column label, open its drop-down arrow, and choose Sort A to Z to arrange text alphabetically; use the same menu to filter which items appear. Sorting changes the order of visible items, while filtering hides selected items, so you can do either or both.

What sorting and filtering do in a PivotTable

A PivotTable summarizes records into categories, such as product names, regions, or dates. Sorting controls the order of those categories; filtering controls which categories are included in the displayed summary. These are separate operations, even though their controls often appear together in a field’s drop-down menu.

For example, imagine a sales report with a row for each product and a total for each product. Sorting the Product field A to Z puts product names in alphabetical order without changing their sales totals. Filtering the field to show only products beginning with a certain letter removes other products from the current view; it does not alphabetize the remaining items by itself.

Sorting a PivotTable does not rearrange the underlying source data. It changes the presentation of the summary. Similarly, filtering a PivotTable does not delete the excluded records from the source table. This makes it possible to explore a summary without altering the data it summarizes.

Sort row or column labels alphabetically

To sort a text field alphabetically in a standard PivotTable layout:

  1. Click the arrow beside the row or column field label. In a compact layout, the field may appear under a general label such as Row Labels.
  2. Choose Sort A to Z for ascending alphabetical order, or Sort Z to A for descending order.

You can also right-click one of the items in the field, such as a product name, and choose Sort > Sort A to Z. This is useful when the field’s drop-down arrow is hard to locate. The sort applies to the field, not just to the particular item you clicked.

If a PivotTable uses tabular or outline layout, field headers may be shown with their own filter arrows rather than a single Row Labels control. Use the arrow for the specific field you want to sort. For example, in a report with Region above Product, sort Product using its own field control if you want the products ordered within each region.

To change the direction later, open the same menu and select the opposite sort order. You generally do not need to remove the field and add it again just to reverse the alphabetic order.

Filter items without changing their order

Open the drop-down arrow for a PivotTable field to see the available items and their check boxes. Clear Select All, select the items you want to keep, and click OK. The PivotTable then displays the selected categories. To restore the full list, open the menu again and select all items, or use the field’s clear-filter command if it is available.

For a long list, use the search box in the field menu to locate an item rather than scrolling through every entry. Searching helps you find a label, but it is not the same as a filter rule: selecting a search result and applying the selection limits the visible items to the chosen labels.

For rule-based filtering, open the field menu and choose Label Filters. Depending on the field, you can set conditions such as begins with, contains, or equals. A label filter is useful when the source list changes and you want the PivotTable to show categories that match a text condition, rather than manually checking individual names. Use Value Filters when the condition should be based on the summarized numbers, such as showing products with a total above a specified amount.

A filter does not normally reorder the items. If you want a filtered list to appear alphabetically, apply the filter and then choose Sort A to Z for that field, or sort first and then filter. The resulting view can be both filtered and alphabetically ordered.

Sort alphabetically or sort by summarized values?

Alphabetical sorting is appropriate when readers need to find labels quickly. But a PivotTable can also sort categories according to their summarized values. For instance, you might sort product names by total sales from highest to lowest to see the strongest performers.

To sort by a value, right-click a number in the relevant values column and choose Sort, then select the desired direction. For more control, choose More Sort Options and specify ascending or descending order by the chosen value field. The exact wording shown can depend on the layout and the value field in the report.

Be clear about which sort you are applying. Sorting the Product field A to Z organizes product names alphabetically. Sorting by Sum of Sales organizes those same products according to sales totals. A value-based sort may look like an irregular alphabetic order, but that is expected: the categories are ranked by their numbers, not by their names.

With more than one row field, the order is hierarchical. If Region is the outer field and Product is nested beneath it, sorting Product usually orders product labels within each region. It does not necessarily create one continuous product list across all regions, because each region is a separate group in the PivotTable.

Numbers, dates, blanks, and custom order

Sort A to Z is intended for text labels. Numeric fields sort numerically, and date fields sort in date order; Excel does not treat every field as ordinary text. A list of numeric labels stored as text can behave differently from actual numbers, particularly when the labels contain different numbers of digits. For example, text values can sort by characters rather than by numeric magnitude.

Dates may be grouped into years, quarters, or months in a PivotTable. If you see grouped date fields, sort the relevant field and check whether the displayed level is the one you intend to arrange. A list of month names may follow a built-in calendar order rather than a simple letter-by-letter sequence, depending on Excel’s sort behavior and settings.

Excel can also use custom lists for familiar sequences, such as weekdays or months. That can be useful for a report where Monday should precede Tuesday even though the words are not alphabetically ordered. If the business requirement is strictly alphabetical, check the result rather than assuming a familiar list will be sorted by its first letter.

Blank labels, extra spaces, inconsistent spelling, and values that look alike can also affect what appears to be a clean alphabetic sort. For example, North and North  with a trailing space may be treated as distinct source labels. Cleaning and standardizing the source column can prevent duplicate-looking categories from appearing in the PivotTable.

What happens after refreshing the PivotTable?

A PivotTable is based on a source range, Excel table, or other data source. When the source changes, use PivotTable Analyze > Refresh to update the summary. The refresh can bring in new category labels or updated values, so review the sort and filter results afterward, especially if the report is used repeatedly.

For a source that grows over time, using an Excel table as the PivotTable source is often more convenient than using a fixed range. Tables expand as rows are added, although the PivotTable still needs to be refreshed to reflect new records. If a newly added label does not appear, check both that the source includes the new data and that a filter has not excluded the label.

Filtering can make a newly added item seem missing even when the PivotTable has refreshed correctly. Open the field menu and check whether the item is unchecked or whether a label or value filter is active. Likewise, a new label may appear at the bottom if the field is manually arranged or subject to a particular sort setting; apply the desired alphabetical sort again if needed.

Common sorting problems and fixes

  • The arrow is missing: Click inside the PivotTable and look for the field’s own drop-down control. If necessary, inspect the field layout and confirm that the field is in the Rows or Columns area, rather than only in Values.
  • The order is not A to Z: Check that you sorted the correct field and that you did not sort by a value field. Open that field’s menu and explicitly choose Sort A to Z.
  • Some labels are absent: Review the item check boxes, Label Filters, Value Filters, and any report filters. A hidden item may be excluded by one of these controls rather than missing from the source.
  • Names appear duplicated: Inspect the source data for spaces, spelling differences, or inconsistent capitalization. Similar-looking text can represent separate category values.
  • New source rows do not show: Refresh the PivotTable and verify its source range. A refresh cannot include records that fall outside a fixed source range.
  • The sort seems to reset: Check whether the field is manually ordered or whether the report uses a custom list. Reapply the sort after refreshing and confirm that the displayed order meets the report’s needs.

On Excel for Mac, the same basic approach applies: use the field’s filter menu or right-click a label to sort and filter. Ribbon placement and menu wording can vary by release. In Excel for the web, click the PivotTable field’s filter arrow and use the available sort and filter options; some advanced PivotTable controls may differ from desktop Excel. If you cannot find a specific command, selecting the field label and opening its context menu is a useful alternative.

When to use a PivotTable filter versus a source filter

Use the PivotTable’s own filter when you want to change only the summarized view. This keeps the source records intact and lets you quickly switch the categories included in the report. It is usually the right choice for interactive analysis, such as comparing selected regions or products.

Filter the source data when the records themselves need to be inspected or edited, or when you need to change which records are included in the PivotTable’s source. A source-table filter changes which rows are visible in that table, but it does not automatically mean the PivotTable has excluded hidden rows; PivotTable source behavior depends on the data source and setup. For predictable reporting, apply the appropriate PivotTable filter and refresh when the source data changes.

If you only need a sorted list and do not need grouped totals, subtotals, or PivotTable filtering, sorting the original Excel table may be simpler. A regular table sort changes the order of source rows, unlike a PivotTable sort, which changes the order of summary categories.

Frequently Asked Questions

Can I sort a PivotTable alphabetically?
Yes. Open the drop-down menu for the row or column field and choose Sort A to Z. For reverse alphabetical order, choose Sort Z to A.

Does filtering a PivotTable sort it alphabetically?
No. Filtering determines which items are displayed; sorting determines their order. Apply Sort A to Z separately if you want the filtered results alphabetized.

Can I sort a PivotTable by total sales instead of product name?
Yes. Right-click a value in the sales column, choose Sort, and select the appropriate order. For a specific value field or more control, use More Sort Options.

Why is a new category missing after I refresh?
Check that the source range includes the new record, refresh the PivotTable, and inspect the field’s filters. The category may be unchecked or excluded by a label or value filter.

Can I alphabetize products separately within each region?
Yes, when Region and Product are nested row fields, sort the Product field. The product labels are arranged within their parent region groups, rather than as one combined list across the entire report.

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.