Copilot in Excel is a new AI-powered chat interface that helps you get insights from and make changes to your data. Type what you want to do, in your own words, and Microsoft Copilot can help you get it done.
Note: This feature is in preview and is changing rapidly. Copilot in Excel currently only understands prompts in English.
Copilot in Excel helps you do more with your data. Starting with a table with data, you can tell Copilot what you want to know using natural language. It can help show correlations, suggest new formulas based on your questions, and generate insights that help you explore your data. Format and organize your data, create visualizations, or ask for general formula column suggestions based on your data.
Get started
Select Copilot on the ribbon to open the chat pane. Enter your prompts and start working with Copilot.
You’ll need to have a table that includes data in a worksheet before using Copilot in Excel. Quickly turn a range of cells into a table by following these steps:
-
Select the cell or the range in the data.
-
Select Home > Format as Table.
-
In the Format as Table dialog box, select the checkbox next to My table as headers if you want the first row of the range to be the header row.
-
Select OK.
-
Explore how Copilot can help you by using the prompt guide.
Note: Copilot in Excel does not yet work with charts, PivotTables, or ranges that are not formatted as Excel tables.
Generate insights about your data
Copilot in Excel can suggest insights based on your table data or your own prompt. It can help with summaries, trends, and outliers, and return insights to you as charts or PivotTable objects.
Here are sample prompts that can be used for Copilot in Excel:
-
Plot sales by category over time.
-
Show total sales for each product.
-
Show the growth of advertising sales from last year.
Make changes to your data with ease
With Copilot in Excel, it's easy to format and edit your tables to organize and highlight data.
Within a single table, Copilot in Excel supports sorting and filtering, applying simple conditional formatting, adjusting cell styles and formatting, adjusting data formats, modifying table styles and properties (banding, total row, and more) and hiding, reordering & deleting table rows and columns.
Here are sample prompts that can be used for Copilot in Excel:
-
Bold the top 10 values in the Sales column.
-
Highlight the highest values in Units Sold.
-
Filter to only show products made in Canada.
Add a formula column to your data
Not sure how to write a formula for a new column? From calculating profits to managing product inventories, Copilot in Excel provides formula suggestions with an explanation of how each formula works.
Here are sample prompts that can be used for Copilot in Excel:
-
Calculate total cost per product in a new column.
-
Add a column that calculates the total profit for each marketing campaign in 2022.
-
Add a column that calculates the number of days after the product launch event.
Notes:
-
Sample prompts are provided as examples only and need to be modified to work with your data.
-
More information about supported languages is available at Microsoft Copilot supported languages.
Additional resources
Frequently asked questions about Copilot in Excel