Copilot for Excel (2026): What It Actually Does, Which License You Need, and 7 Prompts That Work

Copilot for Excel: the short answer

As of September 2026, Copilot in Excel is an assistant pane that edits your workbook directly, plans multi-step jobs before touching cells, or just answers questions about the data, and it runs Python under the hood for analysis. It is included with the Microsoft 365 Copilot add-on ($30 a user a month, or $18 to $21 a user on Microsoft 365 Copilot Business), with Microsoft 365 Premium ($19.99 a month), and with Microsoft 365 Personal or Family through AI credits. Business subscriptions without the add-on get a standard-access version labeled M365 Copilot (Basic).

I install this for owner-led companies that already live in Excel, and the questions are always the same three: what does it actually do, which of the six Copilot SKUs do I need, and why doesn't the button show up. All three answers come from Microsoft's support and pricing pages, read on September 15, 2026.

What Copilot in Excel actually does

Microsoft's getting-started page lists eight things, and the list is more concrete than it was a year ago:

• Edit worksheets: add, rename, and delete sheets; insert and modify values and ranges; apply conditional formatting, data validation, borders, and styles.
• Generate data and formulas: calculations across multiple sheets, summaries, new formula columns.
• Create charts, PivotTables, and shapes with editable links to the source data; build dashboards and templates from scratch.
• Identify insights: ask a question, get charts, PivotTables, summaries, trends, or outliers back.
• Highlight, sort, and filter to focus the sheet.
• Web search with citations to ground a response.
• Import data from other workbooks in OneDrive, SharePoint, or on your computer.
• Custom skills for repeatable processes.

It works in three modes. Edit is the default: Copilot changes the workbook itself, and you watch its reasoning in the pane while cells update live. Plan makes it write out the approach first so you confirm before anything moves. Chat keeps answers in the pane and never touches the sheet. Microsoft's line is "Your content stays editable, and you're in control of everything that's modified," and there's a Stop button if a job goes sideways.

Which license you need

Microsoft's Excel FAQ names four qualifying licenses. Here they are with the prices from Microsoft's own pricing pages today.

Three notes. First, Microsoft's consumer comparison page no longer lists a Copilot Pro plan, and the old Copilot Pro URL now lands on the business page, so I'm not quoting a Copilot Pro price; if you were on it, Premium is the plan Microsoft is pointing consumers to. Second, the add-on needs a qualifying base license: for small business that's Business Basic, Standard, Premium, or Apps for business. Third, "standard access" is Microsoft's phrase, and its overview page defines it as "subject to service capacity availability," meaning the free tier can slow down or step aside at peak times without failing a task in progress. Full pricing detail, including enterprise prerequisites, is in Microsoft 365 Copilot pricing.

The limits Microsoft publishes

• OneDrive and AutoSave. Microsoft's consumer pricing page and subscription FAQ both say Copilot in Excel requires AutoSave, so the file must be in OneDrive, and it does not work with unsaved files. Microsoft's Copilot in Excel tips page, on the other hand, says it "runs in workbooks with autosave enabled or disabled." Two Microsoft pages, two answers. My rule: keep the workbook in OneDrive or SharePoint and you sidestep it.
• Calculation must be Automatic. Editing is only supported when Calculation Options are set to Automatic. Manual-calc financial models need a switch first.
• Tables or table-like ranges. The direct-answer analysis works on single tables, table-like ranges, or several of them; Microsoft says unstructured data is not supported. A merged-cell report with headers in row 4 will confuse it.
• Direct edits are real edits. When Copilot saves changes, anyone with the file sees them, including coauthors. Undo and version history are your safety net.
• SharePoint check-out breaks it. A file checked out in SharePoint throws "Unsupported file state" on Windows and Mac; use Excel for the web or check it in. Strict Open XML files aren't supported either; save as .xlsx.
• Python-mode results are static unless you switch to advanced analysis mode, where the code lands in refreshable Python cells.
• Admins can't turn it off separately. Copilot in Excel is a Copilot Chat tool and follows the Copilot Chat access settings, not its own switch.
• Accuracy. Microsoft's own FAQ says to avoid using it for decisions in sensitive areas such as finance, legal, or medical topics, and to verify anything it creates. Treat that as advice from the vendor, not a disclaimer.

Python in Excel and advanced analysis

When you ask a question in the pane, Microsoft says Copilot "uses Python-based analysis to interpret your question, identify relevant data in your workbook, and compute a response." You get a direct answer with an optional code block you can expand, with comments, and you can ask Copilot to summarize the code to check its logic. This mode does not modify the workbook; it may hand you a static table or image to insert.

Ask for "deeper results using advanced analysis mode," or type "Enter advanced analysis mode," and Copilot opens a new sheet and inserts Python code you can modify and keep as refreshable Python cells. Microsoft's example prompts in that mode go as far as "Use clustering to segment customers based on spending" and "What happens to my loan payments if interest rates increase by 2%?" For a business owner that means forecasting and what-if work without writing a line of code, and a sheet you can hand to an accountant who can.

7 prompts that work

These are built from the prompt patterns on Microsoft's insight, visualization, and direct-answer pages, adapted to the workbooks I actually see: a sales log, an invoice list, a job-cost sheet.

1. "Which region had the highest and lowest sales?" Returns a direct answer with the numbers and, if you ask, a chart. Name the column ("in the Territory column") for accuracy; Microsoft's own tip is that naming columns produces better results.
2. "Add a column that calculates the profit margin for each product." Adds the formula column and explains the formula. The same pattern works for "each region's percentage of total sales."
3. "Create a column that looks up the quantity in stock for each item from the Inventory sheet." Builds an XLOOKUP-style lookup across sheets. This is the prompt that replaces the VLOOKUP tutorial your bookkeeper never finished.
4. "Create a PivotTable with the sum of sales, with month in rows and category in columns." Produces the PivotTable with editable links to the data. Vague versions ("make a PivotTable") work but ask you to refine.
5. "Are there any outliers or anomalies in this data?" Runs the Python-based scan and lists them with the source rows referenced. Good first pass on an expense export before month close.
6. "Review the customer feedback on this sheet and identify major themes." Summarizes free text into themes and sentiment as a new column, with superscript citations back to the source cells.
7. "Explain the formula in cell D3." Plain-English explanation of an inherited formula. I run this on every model a client hands me before I trust it.

Two prompt habits from Microsoft's tips page worth adopting: start broad, then refine, and ask follow-ups instead of new questions, because Copilot keeps the context of the previous one.

How I roll it out for an owner-led business

1. Move the workbooks that matter into OneDrive or SharePoint and turn AutoSave on. This fixes 80% of "the button isn't there" tickets before licensing is even discussed.
2. Start on the included tier. Every eligible business plan already has Copilot Chat and standard access in Excel. Let the team use it for two weeks. The people who hit the capacity wall or need Agent Mode are your add-on candidates.
3. Buy the add-on for those people only. At $18 to $21 a user on Copilot Business through year-end, that's a small line. Assign licenses in the Microsoft 365 admin center; Microsoft's docs also note users need Microsoft Entra ID accounts and, for Excel on the web, third-party cookies allowed.
4. Enable Anthropic as a sub-processor in the admin center if you want the Claude option in the model picker. It's off until an admin allows it.
5. Set one rule: plan mode for any workbook that leaves the building, chat mode for anything you don't want touched.

Copilot in Excel vs Claude for Excel

The honest comparison is short. Copilot is the native option: it edits the workbook, it's bundled into plans you may already pay for, and it now runs Claude models when an admin allows it. Claude for Excel is Anthropic's add-in on a Claude plan, and it's the one I reach for on long modeling sessions where you want the same assistant that's reading your contracts and emails. If your company standardizes on Microsoft 365 and Teams, Copilot wins on friction; the same logic drives my take on Copilot in Teams. If you're deciding between assistants for the whole business rather than one app, start with Copilot vs ChatGPT and pick the platform first, the Excel feature second.