AI Assistant
PRODUCT OVERVIEW
Copilot in Excel is the AI assistant built into Microsoft Excel, part of Microsoft 365. It lets you describe what you want in plain language and then helps edit formulas, tables, and formatting, with changes you can review before applying. It can suggest the right formula for your data, add columns or highlight key information, and move from a simple prompt to deeper insights directly in the spreadsheet, without advanced Excel skills. Copilot in Excel requires AutoSave to be enabled, so the file must be saved to OneDrive; it does not work with unsaved files. Access is available through Microsoft 365 subscriptions that include Copilot, and a free Microsoft Excel plan offers web-based spreadsheets with sharing and collaboration.
Open your workbook in Microsoft Excel and make sure AutoSave is on so the file is saved to OneDrive; Copilot in Excel does not function with unsaved files.
Tell Copilot what to change and it can help edit formulas, tables, and formatting; review the suggested changes and stay in control.
Ask Copilot for help figuring out the right formula for your data so it can handle calculations for you.
Use Copilot to add new columns or highlight key information in your spreadsheet.
Start with a simple prompt and let Copilot build analysis directly in your spreadsheet to reach deeper insights.
Editing spreadsheet formulas, tables, and formatting with plain-language prompts
Calculating results by asking Copilot for the right formula
Formatting data by adding columns or highlighting key information
Moving from a simple prompt to deeper data insights without advanced Excel skills
Collaborating on worksheets with peers and team members
It is the AI assistant built into Microsoft Excel that helps edit formulas, tables, and formatting and turn prompts into data insights.
No. Copilot in Excel requires AutoSave to be enabled, meaning the file must be saved to OneDrive; it does not function with unsaved files.
Yes. You can tell Copilot what to change and it can help edit formulas, tables, and formatting, and you review the changes and stay in control.
Yes. You can ask Copilot for help figuring out the perfect formula for your data so it can do your calculations for you.
Yes. The free Microsoft Excel plan is for one person and includes Excel for the web, sharing and real-time collaboration, and 5 GB of cloud storage.
Microsoft 365 Personal, Family, and Premium list desktop apps with Microsoft Copilot; Premium adds advanced Copilot and agentic AI features.
No. AI features are only available to the subscription owner and cannot be shared, and usage limits apply.
Microsoft 365 Personal is listed at $99.99 per year, and the subscription automatically renews unless canceled in the Microsoft account.
Prices shown are for the yearly billing option in US dollars and renew automatically unless canceled in the Microsoft account. AI features are available only to the subscription owner and cannot be shared; usage limits apply. Copilot in Excel requires AutoSave to be enabled, meaning the file must be saved to OneDrive.
A free Microsoft Excel plan for one person with web-based spreadsheets and real-time collaboration.
A subscription for one person that includes desktop Word, Excel, PowerPoint, Outlook, and OneNote apps with Microsoft Copilot.
A subscription for one to six people that adds shared storage and multi-device use on top of Microsoft 365 Personal.
A subscription that adds advanced Copilot and agentic AI features on top of Microsoft 365 Family.
COMMUNITY REVIEWS
No reviews yet.
Microsoft's AI assistant built into Word, Excel, PowerPoint, Outlook, and Teams, grounded in your work data with Work IQ.
WPS AI brings writing, design, reading and data assistants into WPS documents, spreadsheets and presentations, with basic features available on the web.
