Highlight, sort, and filter your data with Copilot in Excel
With Microsoft 365 Copilot, it's easy to highlight, sort, and filter your tables (or data in another supported format) to quickly call attention to what matters to you.
With a single table, you can effortlessly:
-
Sort and filter your data.
-
Apply conditional formatting.
To get started, format your data in a supported format and select the Copilot button in the ribbon.
Then, tell Copilot how you'd like to manipulate the table to better view portions of your data. You can type in your own words or use the suggested prompts.
Give it a try
To highlight your data, try this:
-
Bold the top 10 values in the Sales column.
-
Highlight the highest values in Units Sold.
To sort your data, try this:
-
Sort engagement rate from smallest to largest.
To filter your data, try this:
-
Filter to items that are due next week.