Where Is Copilot in Excel? How to Find the Button — and Why It Might Not Be There

Guide · Updated September 2026 · ~10 min read

Everyone says Excel has Copilot now. You have opened Excel, scanned the Home tab where every screenshot puts the button, and found nothing there. "Where is Copilot in Excel" is a reasonable question with about nine possible answers — and in 2026 the most likely one is simply that you are looking in the wrong place, because Microsoft moved it.

Work through this in order and you will either open Copilot or find out precisely which of licence, channel, account, policy or platform is in the way. The commercial question — whether it is worth buying if you don't have it — is at the very end, where it belongs.

Where is Copilot in Excel? The short answer

It is in the lower-right corner of the grid, floating over the sheet. Not a ribbon tab, and no longer a fixed button on the Home tab. Microsoft's Get started with Copilot in Excel page is blunt about it: "Select the Copilot icon in the lower-right corner of Excel."

That is the Copilot Dynamic Action Button, and it is why half the guides you have read are wrong. Per Microsoft's documentation for the button, it is now "a single, consistent entry point" in "a consistent corner location in Word, Excel, and PowerPoint, on Windows, Mac, and the web". It rolled out worldwide between April and June 2026, with GCC, GCC High and DoD environments following from October 2026. Anything written before that points at the Home tab in good faith.

Two things worth knowing immediately:

• You can move it back. Right-click the button and choose Move to ribbon. On Windows and macOS that preference persists per app; on the web it applies to the current session only.
• It only appears if you are licensed. Microsoft is explicit: "The Copilot Dynamic Action Button only appears for users who have access to Copilot (through a Microsoft 365 Personal, Family, or Premium subscription; or a Microsoft Copilot license)." No button anywhere is a licensing signal first, a bug second.

Once open, the pane offers three modes — allow editing, plan and chat only. If you can see the pane and it refuses to edit, skip to the file-state section near the end; that is a different fault.

Which Microsoft 365 plans include Copilot in Excel

This is the step people skip, and it accounts for most missing buttons. Microsoft's Copilot in Excel FAQ lists four eligible routes: a Microsoft 365 Personal or Family subscription with an AI credits plan; a Microsoft 365 Premium subscription; a commercial Microsoft Copilot subscription; or a Copilot Chat-eligible Microsoft 365 or Office 365 business or enterprise subscription.

The subtlety that catches business users is that "Copilot Chat-eligible" and "has Copilot in Excel" are not the same thing. Microsoft's admin documentation splits it into three tiers, and the lowest one explicitly excludes the Office apps.

One footnote that is easy to miss: Microsoft states plainly that "Copilot isn't available when using device-based licensing for Microsoft 365 Apps for enterprise", which quietly rules out shared lab and kiosk deployments.

The nine-step diagnostic

In order. The first four settle the overwhelming majority of cases, and each takes under a minute.

1. Look in the bottom-right corner of the sheet, not the ribbon. Open a normal .xlsx workbook — not a blank window, not Protected View — and check the corner of the grid. If you find it, right-click and choose Move to ribbon so it stops hiding.
2. Read the label on the Copilot experience you actually have. Microsoft now displays in-product labels in Word, Excel, PowerPoint and OneNote "to help users identify their Copilot experience". If yours says Copilot Chat, you have the tier that does not include the Excel pane, and no amount of troubleshooting will produce one.
3. Check which account Excel is signed into. File > Account, top-left. If your Copilot licence is on you@firm.com and Excel is signed in as you@outlook.com, there is nothing to find. Sign out, sign back in with the licensed account, and restart Excel.
4. Refresh the licence. A newly assigned Copilot licence often does not reach the desktop app until you force it. File > Account > Update License, then close and restart every Office app — Outlook included, since it holds the session open. On a Mac: the Excel menu > About Excel > More Info > Refresh License.
5. Update Excel. File > Account > Update Options > Update Now. Microsoft's own troubleshooting article opens with "make sure you are running the latest build" rather than naming a minimum version, so update rather than hunting for a build number.
6. Check your update channel. File > Account, under Product Information. If it reads Semi-Annual Enterprise Channel, that is your answer — see the next section.
7. Turn the privacy settings back on. File > Account > Account Privacy > Manage Settings. Both "Experiences that analyze your content" and "All connected experiences" must be on. These get switched off by well-meaning IT hardening policies far more often than people expect, and Copilot vanishes without explanation when they are.
8. Ask whether an admin has switched it off. Tenant admins can remove access entirely through the Copilot controls in the Microsoft 365 admin centre, and there is a dedicated AI Administrator role for exactly this. Copilot also needs WebSocket connectivity to *.cloud.microsoft and copilot.cloud.microsoft — blocked by a proxy, TLS inspection or a firewall rule, entry points fail to appear — and the Office Feature Updates task has to be running. All three are IT questions, not user ones.
9. On Excel for the web, allow third-party cookies. Microsoft is specific: "For Copilot to work in Word Online, Excel Online, and PowerPoint Online, you must enable third-party cookies." Blocked cookies break licence validation and the button never renders. Refresh the page afterwards.

Current Channel vs Semi-Annual — and what changed in July 2026

This one deserves its own section because it explains the most maddening version of the problem: your colleague has Copilot, you have the same licence, and your Excel does not show it.

Microsoft's support guidance has been consistent: "When using Semi-Annual Enterprise Channel of Microsoft 365, Microsoft Copilot features are not available in your apps. In order to use the features enabled by your assigned Copilot license, you'll need to switch to Current Channel or the Monthly Enterprise Channel." Many finance and professional-services firms sit on Semi-Annual precisely because they do not want Excel changing under a close deadline — a defensible choice that also costs you Copilot.

What changed: beginning with the Version 2606 update release in July 2026, Microsoft unified Semi-Annual Enterprise Channel into Monthly Enterprise Channel. Per Microsoft's channel unification article, "Devices with users that meet Microsoft Copilot requirements will become eligible for Copilot after the update because they are on the Monthly Enterprise Channel experience." After 2606 installs, File > Account shows Monthly Enterprise Channel even though management tooling may still report Semi-Annual; builds numbered above 20131.20000 have taken the update.

So the practical question for IT is no longer "will you switch channels for me" but "have we taken the 2606 update yet". Organisations that pinned themselves to Version 2508 to delay it were supported only through 8 September 2026, so most will have moved. Check the article above for where this stands now rather than trusting this paragraph in six months.

Signed into the wrong account — subtler than it sounds

Worth expanding on step 3, because the failure is rarely as obvious as the wrong email address on screen. Copilot for work requires a Microsoft Entra account, so a personal Microsoft account on a work machine gets you consumer Copilot on the web and nothing in the Excel grid. Excel can also be signed into the right account while the file is open from the wrong OneDrive — close it, confirm the account under File > Account, and reopen from the licensed tenant's storage. And licences assigned to guest accounts, shared mailboxes or service accounts routinely fail to reach the human using them; ask whoever assigned it to confirm it landed on the account you sign in with, then run Update License again.

Desktop, web, Mac and mobile do not behave the same

Copilot in Excel is, per Microsoft's FAQ, "available across platforms, including Excel on Windows, Mac, the web, iPad, iPhone, and Android" — but the capability is not level. Edit, plan and chat work on Windows, Mac and the web; iPad gets chat and plan, with edit rolling out; iPhone and Android get chat only. If you tested on your phone and concluded Copilot cannot edit workbooks, that is the platform talking. There is also one case where the web is the only option: where your organisation requires check-out for editing in SharePoint, Microsoft states Copilot on Windows or Mac will not work for files from that site.

The COPILOT() function is a different thing from the Copilot pane

A lot of "where is the Excel Copilot function" searching is people who have the pane and cannot find the function, or have read about the function and cannot find either. They are separate products with separate gates.

=COPILOT(prompt_part1, [context1], [prompt_part2], [context2], ...)

So =COPILOT("Classify each expense description as Travel, Software, Fees or Other.", B2:B40) wrote categories into cells. The reason you cannot find it, though, is simpler than any setting:

• Microsoft retired it. Under message centre notice MC1454373, from 14 September 2026 the =COPILOT function is no longer available and no new formulas using it can be created. It shipped in August 2025, never left the Frontier and Microsoft 365 Insider preview programmes, and lasted about a year. If Excel does not recognise the name, that is why — and no setting brings it back. The Copilot side pane is Microsoft's replacement for the same jobs.
• While it existed it needed its own licence. Work and school accounts needed a Microsoft Copilot add-on; individuals needed Microsoft 365 Premium. Worth knowing only if you are reading older guides that still describe it.
• It is rate-limited. "You can calculate up to 100 COPILOT functions every 10 minutes."
• Sensitivity labels block it. It "cannot calculate in workbooks labelled Confidential or Highly Confidential" — which is how most client files end up classified.
• It is context-blind. It only sees the ranges you pass as context arguments, not the rest of the workbook.

Microsoft also publishes a when-not-to-use list: not for numerical calculations that need accuracy or reproducibility, not for lookups, and not for tasks with legal, regulatory or compliance implications. What that means for finance work is unpacked in what Microsoft Copilot in Excel can't do for accountants — in short, use it on messy text, convert results to values immediately, and keep SUMIFS and XLOOKUP doing anything that lands in a statement.

You found the button, but Copilot won't touch the workbook

A different fault with a short checklist. Microsoft's FAQ names each of these:

• Calculation mode. "Copilot editing is only supported when Calculation Options are set to Automatic." If you run models on Manual, edit mode is dead until you switch back.
• File format. Legacy formats and Strict Open XML Spreadsheet are unsupported. File > Save As and choose Excel Workbook (.xlsx).
• SharePoint check-out. A file checked out produces an "Unsupported file state" error. Check it back in, close and reopen.
• AutoSave is not the gate people think. You will read everywhere that Copilot requires AutoSave and therefore OneDrive. Microsoft's current Copilot in Excel tips page says the opposite — it runs in workbooks with autosave enabled or disabled — while older Microsoft pages still say otherwise. Verify on your own tenant before rearranging your file storage on the strength of a forum post.

If it turns out your plan doesn't include it

Then stop troubleshooting. No registry key, ribbon reset or reinstall adds Copilot to a plan that does not carry it, and the pages promising otherwise are wasting your afternoon.

Your options, cheapest first. Use Copilot Chat on the web — if your business plan is Copilot Chat-eligible you already have it at m365copilot.com, and uploading a workbook to it costs nothing extra. Ask a free chatbot for the formula and place it yourself; for a single SUMIFS or a tricky nested IF, that is most of the value. Learn the tool that solves the underlying problem — a great deal of what people want Copilot for is repetitive cleanup that Power Query does deterministically, for free, and reproducibly next month. Only then buy a licence: consumer means a Personal, Family or Premium subscription; business means the Microsoft 365 Copilot add-on on top of an eligible plan, with current prices on Microsoft's pricing pages and the SKU-by-SKU breakdown in our guide to AI in Excel for accountants.

Be clear about what you are buying. Copilot in Excel is a good Excel assistant — summaries, charts, PivotTables, formulas, cleanup. It is not an accounting assistant: Microsoft documents no connector to QuickBooks, Xero or any other ledger, and nothing it produces goes back to one. If that gap is your real problem rather than the missing button, the wider field of AI Excel tools and the routes to running Claude inside Excel cover the non-Microsoft options. Ours is one of them, and its constraints matter more than its features here: HISAB 360 is a paid add-in for Windows desktop Excel only — no Mac, no Excel on the web, which is exactly where Copilot does work. It is not a Copilot substitute for general spreadsheet help; it is a chat panel with two-way connections to six accounting systems. If you simply wanted a smarter Excel, buy the Microsoft licence.

Frequently asked questions

Try HISAB 360 on your own workbook

HISAB 360 is an AI assistant inside Excel for accountants and finance teams — it writes macros, Power Query and formulas from plain English, and connects two-way to QuickBooks, Xero, Zoho Books, Odoo, FreshBooks and Sage. The 15-day trial is the full product, no card required.