If you have wondered how to use Copilot in Excel without wading through Microsoft marketing, here is the honest version for 2026. Copilot is the AI assistant built into the Excel ribbon that can write formulas, summarize tables, and suggest charts from plain-English prompts. It is genuinely useful for some jobs and a waste of a subscription for others, so the real skill is knowing which is which.
What changed in 2026
The big shift is that Copilot now works directly on the data in your grid, not just as a side chat. Earlier versions mostly answered questions in a task pane; the current build can read a selected range, propose a formula, and drop it into a new column for you to accept or reject. It also handles natural-language data analysis across a whole structured table rather than reasoning one cell at a time.
Two caveats worth knowing up front. It works best when your data is a proper Excel table (select your range, then Insert then Table), and it still cannot hold an enormous workbook in context all at once, so very large sheets get summarized or truncated.
Getting it into Excel: the licensing maze
Copilot is not free with a standard Office install. You generally need one of two paid paths, and this is the single most common reason people cannot find the button.
| Access path |
Who it fits |
Rough monthly cost |
Watch out for |
| Copilot Pro |
Individuals, freelancers |
About the price of a streaming bundle |
Also needs an active personal Microsoft 365 plan |
| Microsoft 365 Copilot |
Businesses, teams |
A higher per-seat add-on |
Often an annual commitment plus admin setup |
| Free web or one-time Office |
Casual users |
No in-grid Copilot at all |
The feature simply will not appear |
Prices move, so treat those as directional and confirm the current figures before you buy. The practical checklist: make sure your Excel is a subscription build (Microsoft 365, not Office 2021 or 2024), that you are signed in with the licensed account, and that the account has the Copilot license attached. Miss any of the three and the button stays hidden.
What Copilot in Excel actually does well
A few tasks are where it earns its keep:
- Explaining and writing formulas. Describe what you want in plain English ("flag rows where spend is over budget and status is open") and it drafts a working formula, then explains what each part does. This is a fast way to learn as much as to save time.
- Summarizing and highlighting. It can surface totals, trends, and outliers across a table without you building a pivot by hand.
- Suggesting charts and pivots. Good for a quick visualization while exploring, not yet presenting.
- First-pass cleanup ideas. It will point out inconsistent formats or likely duplicate columns.
The theme is drafting: a strong starting point that beats the blank page, not a finished analyst.
Where it still trips up
Be skeptical here, because the failures are quiet. Copilot can produce a formula that looks right, runs without error, and returns a plausible but wrong number, especially with nested logic, date math, or lookups across sheets. It does not know your business rules unless you spell them out. On large or messy data it may work off a sample and present the result as if it saw everything. And it sometimes only suggests a change in the chat rather than applying it, which trips people who expect it to edit the grid every time.
There is also a data boundary to respect. In business tenants your prompts are handled under your organization's Microsoft 365 data terms, but still avoid pasting regulated or secret data into any AI feature until you confirm your policy allows it.
A workflow that actually works
Keep it tight. First, format your data as a table so Copilot has clean structure. Second, ask for one thing at a time in specific language, including the rule ("count only closed deals from Q1"). Third, read the explanation, not just the answer. Fourth, spot-check the output against a row you can compute by hand. Fifth, save a version before accepting anything that changes many cells. Treat it like a fast junior colleague whose work you always review.
FAQ
Do I need to be online to use Copilot in Excel?
Yes. It runs in the cloud, so an internet connection and a signed-in licensed account are required; it will not work offline.
Can Copilot build an entire spreadsheet from scratch?
Not reliably. It is far better at editing, explaining, and analyzing an existing table than at architecting a full model, which still needs a human to structure.
Will it work on my old Excel?
Only if that Excel is a Microsoft 365 subscription build with a Copilot license. One-time purchases like Office 2021 or 2024 and the free web version do not include the in-grid assistant.
Is the free version of Excel enough?
For basic formulas and charts, yes. Copilot only makes sense if you do heavy, repetitive analysis and the time saved clearly beats the subscription cost.
Where to go next
If you are weighing whether AI subscriptions are worth the money at all, read our take on whether ChatGPT Plus is worth it in 2026. For private, offline analysis on your own machine, see the local LLM setup guide. And if you are building AI features and the bills climb, our guide on how to reduce AI API costs covers the practical levers.