Yes. In Excel for Microsoft 365 on Windows, a slicer can use Excel’s custom lists to order its items: select the slicer, open Slicer > Slicer Settings, and enable Use Custom Lists when sorting. This changes the displayed order of matching slicer labels; it does not change the underlying data or the slicer’s filtering behavior.
What a custom list means in Excel
A custom list is an ordered set of text values that Excel recognizes as a sequence rather than sorting only alphabetically. Excel includes familiar lists such as the days of the week and months of the year. You can also create your own sequence for labels that have a meaningful order in your work, such as business stages, school terms, or priority levels.
For example, an alphabetical sort of workflow labels might put “Approved,” “In progress,” and “New” in an order that does not reflect how work moves through a process. A custom list can specify New, In progress, Approved, so a slicer that uses custom-list sorting presents those labels in that sequence. The list controls presentation, not the meaning of the values: it will not convert text into a numeric ranking or change a record’s status.
Custom lists are also useful outside slicers. Excel can use them when sorting ranges and PivotTable labels, and they can help when you fill a series by dragging the fill handle. The slicer option applies that familiar Excel ordering behavior to the slicer’s item buttons.
How slicer sorting and filtering work
A slicer is a visual filter connected to an Excel table or PivotTable. Each button represents an item in the field, such as a department, product, or status. Clicking a button filters the connected data to show the selected item; selecting more than one item can show records matching those selections. Sorting controls where the buttons appear, not which records are included.
By default, slicer items are usually arranged in ascending order. The Slicer Settings dialog provides sorting choices, including ascending or descending order, and—when available for that slicer—the option to use custom lists. With the option enabled, Excel can place items that match a custom list in its specified sequence. A slicer remains a filter even when its buttons are arranged in a special order.
This distinction matters when someone assumes a slicer is “wrong” because its buttons are not alphabetical. If a custom list is active, the order may be intentional. Conversely, switching the custom-list option off does not clear a filter or change selected buttons; it only changes how the item labels are sorted.
Turn on custom-list sorting for a slicer
In Excel for Microsoft 365 on Windows, use these steps for a slicer connected to a PivotTable:
- Click the slicer so its contextual ribbon tab appears.
- Choose Slicer > Slicer Settings.
- In the dialog’s sorting and filtering options, select Use Custom Lists when sorting.
- Confirm the setting, then check the slicer buttons against the intended sequence.
If the slicer is already set to ascending order, it can still show a custom sequence: ascending describes the general sort direction, while the custom list supplies a non-alphabetical order for its recognized values. The exact wording or availability of settings can vary with the kind of slicer and Excel release. If you do not see the checkbox, confirm that the slicer is selected and open its settings dialog rather than looking in the worksheet’s general sort controls.
On Excel for Mac, select the slicer and look for its contextual Slicer tab and Slicer Settings. Ribbon layout and dialog options can differ by release. Excel for the web has fewer authoring controls than the desktop application, so if the custom-list setting is not available there, configure and verify it in desktop Excel.
Create or check the custom list
The slicer can only follow an order that Excel knows as a custom list. In Windows Excel, open File > Options > Advanced. In the General section, choose Edit Custom Lists. You can select a built-in list, type a new list into the list entries box with each value on its own line, and choose Add. You can also select a worksheet range in the import area and use Import to make its entries into a list.
On Mac, custom lists are managed through Excel’s settings or preferences; the exact menu label depends on the release. Look for Custom Lists in Excel’s application settings. Create the list in the order you want Excel to use, and then return to the slicer settings to ensure custom-list sorting is enabled.
- Keep the list focused on one field’s labels rather than mixing unrelated categories.
- Use the same wording as the data values. Differences such as extra spaces, abbreviations, or alternate spellings can prevent a value from behaving like the intended list item.
- Make the sequence complete when possible. If some slicer labels are absent from the list, those labels have no position specified by that custom sequence and are handled by Excel’s regular sorting behavior.
Example: ordering workflow stages
Imagine a project tracker with a Status field containing New, In progress, Waiting for review, and Complete. An ordinary alphabetical order would put Complete before In progress and New, which is usually not a helpful way to scan the workflow. Create a custom list in the process order—New, In progress, Waiting for review, Complete—then enable custom-list sorting in the slicer settings.
After that, the slicer can show the status buttons in the order people use to understand the process. Clicking Waiting for review still filters the connected table or PivotTable to that status; the custom list does not cause Excel to select it automatically. If a new status such as On hold is added later, add it to the custom list in the desired position if you want the sequence to account for it. Otherwise, Excel will sort that unlisted label using its regular behavior.
This approach is especially useful when users scan a slicer from left to right or top to bottom to understand progression. It is less useful when the field is a set of unrelated names, where alphabetical order may be easier to navigate.
What the setting does not change
Custom-list sorting is an ordering aid, not a data-cleanup or modeling feature. It does not rename source values, remove duplicates, fix inconsistent status labels, or impose a permanent rank on each record. If one record says In progress and another says In Progress, review the source data for consistency rather than expecting the custom list to merge them.
It also does not reorder the source rows in a worksheet. A slicer is a separate control; its button arrangement is not evidence that the underlying records have been physically sorted. Likewise, changing the order of a slicer’s buttons does not itself change a chart’s series order or a table’s row order. Those display elements have their own sorting and layout settings.
Custom lists are generally an Excel application setting on the computer, not a self-contained part of the worksheet data. That means a workbook shared with another person may not reproduce a locally defined list’s behavior on their computer unless the list is available there too. For a workbook used by a team, document the desired sequence or provide a setup note, and test the workbook on the environment where it will be used.
Common problems and fixes
- The items remain alphabetical. Reopen Slicer Settings and check that Use Custom Lists when sorting is selected. Confirm that the list contains the slicer’s actual labels and is in the intended order.
- Only some values follow the sequence. Check for labels missing from the custom list, spelling differences, extra spaces, or multiple forms of the same category. Add valid missing labels or standardize the source data.
- The slicer order changed but the report did not. That may be expected. Slicer button order is separate from the sort order of rows in the connected table, PivotTable, or chart.
- A colleague sees another order. The colleague may not have the same custom list in their Excel settings, or may be using a different Excel version or platform. Confirm the setting and list on that computer.
- The option is not visible. Select the slicer itself and open its settings from the contextual Slicer tab. If the option is still absent, the slicer type or Excel build may not expose it; test in desktop Excel for Microsoft 365 on Windows.
When troubleshooting, change one thing at a time. First verify the custom list itself, then the slicer setting, and finally the field’s source labels. This makes it easier to distinguish an unavailable feature from a list that simply does not match the data.
When to use another ordering method
Use a custom list when the categories have a stable, meaningful sequence and Excel’s built-in ordering is not suitable. Good examples include stages in a process, months in a fiscal year that starts in a non-January month, or a short set of priority levels. For ordinary product names, cities, or employee names, alphabetical sorting is often more predictable.
If the order must be explicit and consistent across many workbooks or users, consider storing a numeric sort key alongside each category in the source data—for example, 1 for New, 2 for In progress, and so on—and sorting the report by that key. Keep the displayed category label separate from the key so readers see meaningful text. This method takes more setup, but the order is represented in the data model rather than relying only on an individual Excel installation’s custom-list settings.
For a one-off report, manually rearranging source data is usually not the right fix: it does not establish a reusable category order and may be undone by refreshes or later edits. Choose the simplest approach that matches the workbook’s audience and how reliably the order must travel between computers.
Frequently Asked Questions
Can an Excel slicer use a custom list to sort its buttons?
Yes, when the slicer’s settings offer Use Custom Lists when sorting. Enable it in Slicer Settings and make sure the custom list contains the field labels in the order you want.
Where do I find Use Custom Lists when sorting?
Select the slicer, choose Slicer > Slicer Settings, and look in the sorting and filtering options. The dialog can vary by Excel version and slicer type.
Can I make months appear in fiscal-year order?
Yes. Create a custom list with the months in the fiscal sequence you need, then enable custom-list sorting for the slicer. The source values still need to match the month labels in that list.
Does custom-list sorting filter or rearrange the worksheet data?
No. It changes the order of slicer items, not the selected filter and not the physical order of source rows. Use the table or PivotTable’s own sort controls if you need to rearrange report data.
Will my custom list travel with the workbook?
Do not assume it will. Custom lists are generally maintained in Excel’s local settings, so another user may need to create the same list and enable the slicer option on their computer.
Related
- Excel Slicer Multiple Columns: What Works and What Doesn’t
- Excel Slicer Multiple Selections: How to Use Them
- Excel Slicer Formatting: Styles, Colors, and Layout
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel Formula for Counting Unique ValuesIn Excel for Microsoft 365, use =IFERROR(ROWS(UNIQUE(FILTER(A2:A100,A2:A100<>""))),0) to count distinct nonblank values in A2:A100. It returns 0 if…
- Rank in Excel Formula: Use RANK.EQ and Handle TiesTo find a number’s position in a list in Microsoft Excel, use RANK.EQ. For example, if scores are…
- Excel Named Range vs Table: How to Choose the Right ToolAn Excel named range gives a cell or formula a memorable name; an Excel table organizes related records…
- Excel Date and Time: Formatting, Formulas, and FixesExcel stores dates as serial numbers and times as fractions of a day, so you can format them…
- Excel NPV of a Series of Cash Flows: Formula and ExamplesTo calculate the net present value of a cash-flow series in Excel, use =NPV(B1,B3:B5)+B2 when the discount rate…
- How to Add a Filter to a Column in ExcelTo add a filter in Excel for Microsoft 365 on Windows, click a cell in your data, choose…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.