How to Use Copilot in Excel (2026)

Copilot in Excel writes formulas, explains what a workbook is doing, and builds charts and PivotTables from plain language. Before any of that happens, it imposes requirements the other Office applications do not, and most first attempts fail on those rather than on the prompt.

What Copilot in Excel actually requires

The requirements moved during 2026, and most published guidance still describes the older set.

A modern file format. A current Excel format such as .xlsx, .xlsm or .xlsb. Microsoft names Strict Open XML Spreadsheet as unsupported, and the fix is saving the file as an ordinary Excel Workbook.

Calculation Options set to Automatic. Microsoft states that Copilot editing is only supported with this setting, and it produces a distinctive symptom: Copilot answers your questions and refuses to change anything.

A license that includes Copilot in the Office applications. A missing button is an access question, and the next section covers it.

AutoSave and cloud storage are where Microsoft's own documentation disagrees with itself. Its Copilot in Excel tips page says Copilot runs with AutoSave enabled or disabled. Other current Microsoft pages, including the Excel FAQ, still carry the older requirement that the file sit in OneDrive or SharePoint with AutoSave on.

Both are live, so what you get can depend on your experience, your license and how far the rollout has reached you. Cloud storage also still buys what depends on it, including coauthoring, version history and grounding in organizational content. Read it this way: a cloud-stored workbook is most likely to work everywhere, and a local one is worth trying rather than ruling out.

Table formatting is a recommendation rather than a gate. A table gives Copilot explicit boundaries and named columns, which makes the structure clearer.

Author’s pick: If you’re looking for a cool copilot alternative, you should definitely try out Guidy. It is free and available for Windows, MacOS, as well as Chrome extension.

How to enable Copilot in Excel, and where the button moved to

There is nothing to install. Copilot appears on its own once your account is eligible and two settings are on, which is why "enable" here means finding it rather than adding it.

Where is Copilot in Excel?

Select the Copilot icon in the lower-right corner of the workbook. Microsoft consolidated every entry point into a single Dynamic Action Button anchored there, which is why guides that tell you to look on the ribbon send you to the wrong place. You can move it to sit next to the ribbon if you prefer it there.

What license you need. A Copilot Chat-eligible Microsoft 365 or Office 365 subscription, with the paid add-on on top for the full experience. Microsoft now shows an in-product label so you can see which experience you have, and M365 Copilot (Premium) is the one that means you hold the add-on.

If the button is not there at all. Go to File > Account, select Manage Settings under Account Privacy, and turn on both Experiences that analyze your content and All connected experiences. Either one switched off hides Copilot completely.

Copilot in Excel runs on Windows, Mac, the web, iPad, iPhone and Android, though what you get varies by platform and license.

If the actual problem is that you cannot find a control rather than that you do not know what to ask for, that is the gap Guidy fills: it reads your screen and points at the button in your version of Excel rather than describing where it sits in someone else's.

How to format data for Copilot in Excel

Copilot reasons about named columns and defined boundaries. Give it a loose range for it guess at where your data starts and what your columns mean.

Select any cell in your data and use Home > Format as Table, ticking the option that says your table has headers if your first row contains them. Microsoft recommends clearly structured data, and specific table, range and column references when you prompt.

Column headers do the heavy lifting, so make them say what the column contains. A header reading "Amt2" tells Copilot nothing. One reading "Invoice total" tells it everything.

Clear out the things that break interpretation: blank rows in the middle of the data, subheadings sitting inside the range, merged cells, and manual subtotal rows. If your numbers are still trapped in a document rather than a spreadsheet, our guide to extracting data from PDF to Excel covers getting them across first.

Copilot in Excel prompts (with examples)

Microsoft's own advice is to be specific, and to name the tables or ranges and the column headers you want used. That is the whole technique.

Note: vague prompts produce vague output: "analyze this data" invites Copilot to pick its own question. Naming the target narrows it: "In the Orders table, show total revenue by region for the last four quarters as a column chart."

The Copilot pane includes a prompt guide button offering suggestions by task type, which is a reasonable starting point when you do not know what to ask for.

Choose the mode before you prompt. Editing mode changes the workbook directly. Plan mode works out an approach before touching anything. Chat mode keeps the answer inside the pane and leaves the grid alone, which is the one to use while you are still deciding what you want.

Follow-up prompts work, because Copilot holds the session context. Ask for a breakdown, then refine: "now the same view for one region only".

Ask it to explain as well as to produce. Handing it an inherited formula and asking what it does is one of the things it is reliably good at.

One route is closing rather than opening. Excel briefly carried a =COPILOT() worksheet function that put a prompt directly into a cell, and Microsoft has announced that from September 14, 2026 it will no longer be available, pointing users to the side pane for the same tasks. If you have seen it demonstrated and cannot find it, that is why.

What are the disadvantages of Copilot in Excel?

It edits only the workbook you have open, but it can look further than that. Microsoft documents Copilot in Excel importing data from other Excel workbooks held in OneDrive, SharePoint or on your computer, drawing on Word, PowerPoint and PDF files in those locations, using organizational information such as emails and meetings, and searching the web with citations to the sources used.

What it can actually reach depends on your license and your build, so test the reach rather than assuming it.

It degrades on messy data. Well-structured tables with clean headers produce good results, and unstructured sheets produce unreliable ones. This is the single biggest factor in whether it helps you.

Sensitivity labels can block it. A workbook labeled at a restricted level will refuse certain Copilot actions, including formula generation, and the refusal is by design.

Its changes are visible to everyone with the file. Saved Copilot edits show up for anyone with access, including people in a coauthoring session, and undo or version history is how you take them back.

Availability moves. Features roll out across tenants, channels and platforms at different times, so something documented may not be present in your build yet. Microsoft states plainly that its requirements may change as it updates the product.

Is Copilot in Excel accurate, and how do you check?

Microsoft's own position is that Copilot's insights, formulas and tables are a starting point, that they can be inaccurate, and that generated content should be reviewed and verified. It goes further and advises against using Copilot for decisions in sensitive areas such as finance, legal or medical topics. Take both at face value.

A wrong formula in a spreadsheet does not look wrong. It returns a number, and the number is plausible, and nobody notices until a decision has been made on it. Check any generated formula against a row you can verify by hand before applying it to the whole column.

If the difficulty is finding the setting or the button rather than knowing what you want, our AI for Excel page covers a different approach to the same frustration.

Key takeaways

• Copilot in Excel needs a modern file format and Calculation Options set to Automatic, while Microsoft's own pages currently disagree over whether cloud storage and AutoSave are still required
• Converting your range with Home > Format as Table does more for accuracy than any prompt technique
• Name the table and the column headers in your prompt, because specificity is what Microsoft's own guidance asks for
• A restricted sensitivity label will block certain Copilot actions, including generating formulas
• Microsoft describes its output as a starting point that can be inaccurate, so verify every formula before you trust it

FAQs

How do I enable Copilot in Excel?

There is nothing to install. Select the Copilot icon in the lower-right corner of the workbook. If it is absent, check which Copilot experience your license gives you, then turn on both Account Privacy settings under File > Account > Manage Settings. If it is present but will not act, check the file format, the Calculation Options and which mode you are in.

Is Copilot in Excel free?

Not on its own. It needs a Copilot Chat-eligible Microsoft 365 or Office 365 subscription, and the full experience inside Excel needs the paid Copilot add-on on top of that. A free Microsoft account with Copilot chat on the web does not put Copilot inside a workbook.

What can Copilot do in Excel?

It analyzes data and returns insights, charts and PivotTables, highlights, sorts and filters, writes and explains formulas, and edits the workbook directly in editing mode. Depending on your license it can also import data from other workbooks, draw on files and organizational content, and search the web with citations to its sources.

Where is Copilot in Excel?

In the lower-right corner of the workbook. Microsoft consolidated every entry point into a single Dynamic Action Button anchored there, which is why older guides that send you to the ribbon are wrong. You can move it to sit beside the ribbon if you prefer it there. If it is absent altogether, the cause is your license or the two Account Privacy settings rather than the layout.

How do I turn off Copilot in Excel?

On Windows and Mac, go to File > Options > Copilot and clear the Enable Copilot checkbox, then restart Excel. That is per application and per device, so you repeat it in Word and PowerPoint and on every machine you use. There is no equivalent in the web, iPhone or Android versions.