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 or apply conditional formatting.
Tip: Use Analyst agent ​​​​​​​to get insights on your data within minutes and to analyze information across multiple files.
-
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.
-
Select Apply to make the changes.
Highlight your data
Here are a few prompt suggestions to help quickly highlight your data:Â
-
Bold the top 10 values in the Profit column.Â
-
Highlight the highest values in the Sales column. ​​​​​​​
Sort your data
Here is a prompt suggestion to help sort your data:Â Â
-
Sort engagement rate from smallest to largest.​​​​​​​ ​​​​​​​
Filter your data
Here is a prompt suggestion to help filter your data:Â
-
Filter to items that are due next week.Â
