Copilot in Excel now suggests sort and filter options when you ask questions about your data. This feature helps you quickly narrow down rows or reorder columns without writing formulas or using the Ribbon. The suggestions appear in the Copilot pane after you type a natural language request such as “show top 10 sales” or “filter rows where region is West.” This article explains how the suggestion engine works, what prerequisites are needed, and how to apply the suggestions step by step.
Key Takeaways: Copilot Sort and Filter Suggestions in Excel
- Copilot pane > Natural language query: Type requests like “sort by date descending” to see suggested actions before applying them.
- Data must be in an Excel table (Ctrl+T): Copilot only generates suggestions for structured table ranges, not raw cell ranges.
- Preview before applying: Each suggestion includes a preview of the result so you can confirm the action is correct.
How Copilot Sort and Filter Suggestions Work
Copilot in Excel uses the Microsoft Graph and the Excel data model to interpret your natural language requests. When you type a question or command in the Copilot pane, the system analyzes the column headers, data types, and values in the active table. It then generates one or more suggested sort or filter actions that match your intent.
The suggestions appear as clickable cards in the Copilot pane. Each card shows a short description of the action, for example “Sort the table by Sales Amount from largest to smallest.” You can click the card to apply the sort or filter immediately. If the suggestion is not what you wanted, you can refine your request or dismiss the card.
This feature works only when your data is formatted as an Excel table. To create a table, select any cell in your data range and press Ctrl+T. Copilot also requires a Microsoft 365 Copilot license and an active internet connection. The feature is available in Excel for Windows, Mac, and Excel for the web.
When Copilot Proposes Multiple Suggestions
If your request is ambiguous, Copilot may show several suggestions. For example, typing “show best months” could produce a sort by month name or a filter for months with above-average revenue. Review each suggestion carefully before clicking. You can also type a more specific request such as “sort by revenue descending and filter to year 2025” to get a single combined suggestion.
Steps to Use Sort and Filter Suggestions
Follow these steps to enable and apply Copilot sort and filter suggestions in Excel.
- Open the Copilot pane
In Excel, go to the Home tab and click the Copilot button in the Ribbon. The Copilot pane opens on the right side of the window. - Ensure your data is in a table
If your data is not already formatted as a table, select any cell in the range and press Ctrl+T. In the Create Table dialog, confirm the range and click OK. - Type a natural language request
In the Copilot pane text box, type a request such as “filter to show only completed projects” or “sort by priority high to low.” Press Enter. - Review the suggested action
Copilot displays one or more suggestion cards. Each card contains a description and a preview of the result. Hover over a card to see the preview more clearly. - Apply the suggestion
Click the card that matches your intent. Excel applies the sort or filter to the table immediately. The Copilot pane shows a confirmation message. - Refine or undo the action
If the result is not correct, press Ctrl+Z to undo. Then type a more specific request in the Copilot pane, for example “filter to region East and sort by date ascending.”
Common Mistakes and Limitations
The following issues can prevent Copilot from generating sort or filter suggestions or cause unexpected results.
Copilot Does Not Respond to Natural Language Requests
If Copilot shows no suggestions after you type a request, check that your data is in an Excel table. Copilot ignores raw ranges. Also verify that your Microsoft 365 Copilot license is active and that you are signed in with the correct account. A slow or disconnected internet connection can also block suggestions.
Suggestions Are Incorrect or Irrelevant
Copilot bases suggestions on column headers and data patterns. If your column headers are missing, unclear, or contain merged cells, the suggestions may be wrong. Ensure each column has a unique header in the first row of the table. Avoid blank rows or columns inside the table.
Multiple Filters Overlap or Conflict
When you apply a filter through a suggestion, any existing filter on the table is replaced. If you want to add a second filter, type a combined request such as “filter to region West and status Active.” Copilot then generates a single suggestion that includes both conditions.
Sort Order Does Not Match Expected Sequence
Copilot sorts text columns alphabetically by default. For custom sort orders such as “High, Medium, Low,” you must define a custom list in Excel before using Copilot. Go to File > Options > Advanced > Edit Custom Lists. After you define the list, Copilot recognizes the order in suggestions.
Copilot Sort and Filter vs Manual Excel Sorting and Filtering
| Item | Copilot Sort and Filter Suggestions | Manual Excel Sorting and Filtering |
|---|---|---|
| Input method | Natural language text in Copilot pane | Ribbon buttons or right-click menu |
| Data requirement | Excel table (Ctrl+T) required | Works on any cell range or table |
| Multiple conditions | Type combined request for multi-condition actions | Use Sort dialog or filter dropdown checkboxes |
| Custom sort order | Requires predefined custom list in Excel | Custom lists can be applied directly in Sort dialog |
| Preview before apply | Yes, shown in suggestion card | No preview; result appears after action |
| Undo | Ctrl+Z or dismiss suggestion | Ctrl+Z or clear filter |
Copilot suggestions reduce the number of clicks for common sorting and filtering tasks. Manual methods give you more control over advanced options such as sorting by cell color or using custom list orders without setup.
For most everyday operations like filtering by region or sorting by date, Copilot suggestions are faster and require less knowledge of Excel menus. For complex workflows involving multiple sort levels or conditional filters, the manual Ribbon tools remain the better choice.