How to Use Copilot in Excel: Setup, Prompts and Checks for Everyday Work
If you want to use Copilot in Excel, the hardest part is often getting it to appear at all. Once it does, Copilot can analyze data, suggest formulas, create charts and summarize trends from plain-English prompts. This guide covers the requirements that trip people up, which plans include Copilot, how to prepare your data, prompts that work, and how to check the results before they reach your boss or client. Requirements and plan details come from Microsoft's support and Microsoft 365 plan pages, checked on 15 October 2026.
What you need to use Copilot in Excel
- A plan that includes Copilot. Microsoft's consumer plans Microsoft 365 Personal ($9.99 a month), Family ($12.99) and Premium ($19.99) include Copilot in the Office desktop apps, with Premium offering the most usage. Business plans with Copilot also include it.
- The subscription owner's account. On Family and Premium, Microsoft says AI features in the Office apps are only available to the subscription owner.
- AutoSave on. Microsoft's support pages say Copilot in Excel requires AutoSave, which means the file must be saved to OneDrive.
- Up-to-date Excel. Install the latest updates.
If the Copilot button is missing, check those four things first.
Prepare your data
Copilot works best with clean, structured data:
- Format as a table: select your data and insert a table.
- Clear headers: one row of descriptive column names.
- One record per row: no merged cells, subtotals or notes inside the data.
- Consistent formats: dates as dates, numbers as numbers.
Five minutes of cleanup prevents most wrong answers.
Prompts that work
Open Copilot from the ribbon and try:
Understand the data
- "Summarize this table: what does it contain and what stands out?"
- "Are there any unusual values or outliers?"
Calculate
- "Add a column that calculates profit as revenue minus cost."
- "Add a column showing the month from the order date."
- "Which product had the highest total revenue?"
Analyze
- "Show total sales by region and month."
- "Which customers have not ordered in the last 90 days?"
- "Compare this quarter with last quarter by product."
Visualize
- "Create a line chart of monthly revenue."
- "Create a bar chart of the top 10 products by revenue."
Be specific about the metric, grouping, time period and output.
Check the results
Copilot can misread a column or apply an unexpected filter. Before sharing:
- Inspect added formulas and make sure they reference the right columns.
- Spot-check two or three results by hand.
- Compare totals with numbers you already trust.
- Check chart axes and labels.
- Keep a copy of the original data before large changes.
Everyday use cases
- Sales reports: monthly totals, top products and trends.
- Budgets: variance between planned and actual spend.
- Expense lists: categorize and total by category.
- Inventory: items below reorder level.
- Survey data: counts and percentages by answer.
Copilot in Excel vs ChatGPT for data
Copilot keeps work inside your spreadsheet, which suits recurring reports and shared files. ChatGPT is useful for one-off analysis of an uploaded file. See our Microsoft Copilot vs ChatGPT guide for the broader trade-offs.
Example: a monthly expense review
Say you track business expenses in a table with columns for date, vendor, category, amount and payment method.
- Summarize: "Summarize total spending by category for September."
- Compare: "Compare September spending by category with August, with the difference in dollars and percent."
- Spot issues: "Which vendors appear more than once with the same amount on the same day?" This helps catch duplicate charges.
- Visualize: "Create a bar chart of spending by category for September."
- Check: compare the total with your bank or accounting system before acting.
What used to take an evening of pivot tables now takes a few prompts, and the checking step keeps the numbers reliable.
Writing better Excel prompts
- Name the columns you want used: "using the Amount and Category columns".
- State the time range: "for orders in Q3 2026".
- Say the output: "as a new column", "as a table on a new sheet", "as a bar chart".
- Ask for one thing at a time, then build on the result.
- Ask Copilot to explain a formula it added if you are not sure what it does.
Privacy and data handling
Before using Copilot on a workbook with personal data, such as customer names or salaries, check your organization's policy and remove columns that are not needed for the analysis. For a general checklist on AI and files, see our guide on whether it is safe to upload files to ChatGPT.
Troubleshooting checklist
- No Copilot button: confirm your plan, that you are signed in as the subscription owner, and that Excel is updated.
- Copilot is greyed out: save the file to OneDrive and turn on AutoSave.
- Odd or empty answers: convert your range into a table, fix headers and remove merged cells.
- Wrong totals: check for blank rows, text-formatted numbers and hidden filters.
- Slow responses: try a smaller range or split very large workbooks.
Most problems come down to file location, data structure or plan eligibility, so work through these before assuming Copilot is broken.
Tips for teams
- Store shared workbooks in OneDrive so Copilot and AutoSave work.
- Agree on table formats for recurring reports.
- Document prompts that produce your weekly report, so anyone can repeat them.
- Review sensitive data before using AI features, and follow your company's policy.
For a broader view of Copilot in a small business, see our guide to Microsoft Copilot for small business.
Related reading
For more tools grouped by job, browse our AI tools by profession guide.
Verify the details before you commit
Vendors change plans, limits and features often, so treat this guide as a starting point for use copilot in excel. Before you commit, open the vendor's official pricing and help pages and confirm four things: the current plan names and prices for your region, the limits that matter for your work, what happens to your data and exports if you leave, and how cancellation and refunds work. Write down each answer with the date, test the free plan or trial on one real task, and ask a colleague to repeat your test. If a detail in this article no longer matches the vendor's own page, trust the vendor's page and treat the article as out of date. Keep a short note of what you tested, what worked and what did not, so you can repeat the test in a few months and see whether the tool has improved or whether your needs have changed.
FAQ
Which plans include Copilot in Excel?
Microsoft's consumer plans Microsoft 365 Personal, Family and Premium include Copilot in Excel, with Premium offering the highest usage. Business plans with Copilot also include it.
Why can't I see the Copilot button in Excel?
Common reasons are that the file is not saved to OneDrive, AutoSave is off, or your plan does not include Copilot. Microsoft's support pages say Copilot in Excel requires AutoSave.
Can family members use Copilot on Microsoft 365 Family?
Microsoft says AI features in Word, Excel, PowerPoint, Outlook and Designer on Family and Premium plans are only available to the subscription owner.
Does my data need to be in a table?
Formatting data as an Excel table with clear headers gives Copilot the most reliable results.
Can Copilot make mistakes in Excel?
Yes. Check formulas it adds, spot-check results against known numbers, and review charts before sharing.
Conclusion
To use Copilot in Excel successfully, start with the requirements: the right plan, the subscription owner's account, and a file saved to OneDrive with AutoSave on. Then format data as a table, ask specific questions, and check every result before you share it. Done this way, Copilot turns routine spreadsheet work into minutes.
Sources and methodology
Requirements and plan details come from Microsoft's support pages on Copilot in Excel and Microsoft 365 plan pages (https://www.microsoft.com/en-us/microsoft-365/buy/compare-all-microsoft-365-products), checked 14–15 October 2026. Prices may change.