Get started with Copilot in Excel
Applies ToExcel for Microsoft 365 Excel for Microsoft 365 for Mac Office for business Microsoft 365 admin Excel for iPad Excel Web App Microsoft Office

Copilot in Excel helps you do more with your data by generating formula column suggestions, showing insights in charts and PivotTables, and highlighting interesting data.

Tip: For more great ideas on using Copilot in Excel, check out the Excel blog at http://aka.ms/ExcelCopilotBlog.

  1. Open Excel.

  2. Open a workbook stored on OneDrive or SharePoint.

    Important: Your data needs to be formatted in specific ways (see Format data for Copilot in Excel).

  3. Select Copilot on the ribbon to open the chat pane or select a cell, then select the Copilot icon next to it.The Copilot icon that shows when you select a cell in an Excel worksheet.​​​​​​​

  4. Enter your prompts (or select a prompt if you selected the icon next to a cell), then start working with Copilot. Here are some samples to get you started:      • "Create a bar graph showing the sales growth between Q2 and Q3."      • "Bold the top 3 values in Annual Sales." ​​​​​​     • "Add a new column showing the percentage difference between column A and column C."

    Note: Accessing Copilot from the icon next to a cell not only allows a better flow for the work you're doing, but it helps you discover prompt options so you can gain expertise quickly. The prompts you see may vary.

    Explore more Copilot prompts

Learn more  

Identify insights with Copilot in Excel 

Highlight, sort, and filter your data with Copilot in Excel

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Find solutions to common problems or get help from a support agent.