Copilot in Excel: How to Use It, Where It Fails (2026)

Do I have Copilot in Excel, and how do I turn it on?

If Copilot is missing, Microsoft says your subscription may not include it or your organization may have disabled it. Check the license and organizational settings before troubleshooting the workbook.

1. Confirm your Microsoft 365 subscription and whether it includes Copilot in Excel.
2. For a work account, ask your administrator to confirm access and whether Copilot is enabled.
3. Open Excel and look for the Copilot icon in the lower-right corner.

Prices and plans checked 2026-10-19 on Microsoft’s official pages. USD prices shown to US visitors, excluding tax; this is a pricing reference, not confirmation of Excel entitlement.

Local prices, taxes and rules differ in the UK, Australia and India, so check locally. Our guide to Copilot for professionals provides broader plan context.

What you can do for free: Microsoft offers limited Copilot at $0 per month, subject to available capacity and limits. The Microsoft pages we checked do not establish that it includes the Excel pane. Do not assume free chat access gives workbook-editing access.

How do I use Copilot in Excel step by step?

Choose plan mode when you want to review proposed changes before editing, or chat when you want an answer without workbook changes. Edit is the default and edits the workbook directly.

1. Check your license and organizational access, then open the workbook.
2. Open Copilot using the lower-right icon.
3. Choose edit, plan or chat.
4. Prompt with the sheet, source range, requested calculation and output destination.
5. Review the step-by-step plan Copilot creates. Use plan mode for review before editing.
6. Watch changes live and press Stop if they go off course.
7. Verify formulas, ranges and totals before using the output.

Video placeholder: license check, opening the pane, choosing a mode, prompting, reviewing and stopping.

Platform support checked 2026-10-20 on Microsoft’s support page.

“Not listed” means the cited facts do not confirm that mode. Do not assume mobile access matches desktop access.

Which five tasks can I try with copyable prompts?

Start with table preparation, monthly summaries, pipeline PivotTables, measurement charts and text classification. These are suggested workflows based on documented capabilities, not measured performance results.

Use fictional workbooks with the placeholder fields below. Replace placeholders with suitable sheet names and ranges; confidential data requires the checks in the data section.

Task 1: structure an export and add a formula.

Use plan mode. On [SHEET_NAME], convert [SOURCE_RANGE], including its headers,
into a table named [TABLE_NAME].
Add "Net amount" as [GROSS_COLUMN] minus [DISCOUNT_COLUMN].
Show the proposed steps before editing.
Flag missing inputs rather than inventing values.

Task 2: summarize monthly movements. Our AI for accountants guide provides context for reviewing financial outputs.

Use plan mode. From [TABLE_NAME], propose a new sheet called "MoM summary".
Group [AMOUNT_COLUMN] by [MONTH_COLUMN] and [CATEGORY_COLUMN].
Calculate the percentage change from the previous month.
Flag missing prior-month values and zero denominators for review.
Leave the source table unchanged.

Task 3: build a pipeline PivotTable. For related professional workflows, see AI for sales managers.

Create a PivotTable from [TABLE_NAME] on a new sheet called "Pipeline by owner".
Rows: [OWNER_COLUMN]. Columns: [STAGE_COLUMN].
Values: sum of [DEAL_VALUE_COLUMN].
Sort owners by total value, largest first.
Show the source range in your explanation.

Task 4: chart measurements and flag out-of-range values. Keep units and tolerances explicit, as in our guide to AI for engineers.

Use [TIMESTAMP_RANGE] and [MEASUREMENT_RANGE] on [SHEET_NAME].
Create a line chart titled "[CHART_TITLE]", with measurements labeled in [UNIT].
Apply red fill to measurements above [UPPER_LIMIT] or below [LOWER_LIMIT].
Identify missing or nonnumeric measurements for review.

Task 5: classify fictional feedback.

Classify the entries in [TEXT_RANGE] using these categories: [CATEGORY_LIST].
Write the results in a new column headed "Category".
Add a "Reason" column with a short justification.
Flag ambiguous entries for review rather than forcing a category.
Leave the original text unchanged.

These instructions still require output checks. Copilot also supports web search with citations, importing workbooks from OneDrive, SharePoint or local storage, and custom skills for repeatable tasks. Find additional wording in our prompt library.

Where does Copilot in Excel get it wrong?

We cannot quantify its errors: Microsoft Copilot, including Copilot in Excel, is not in our test bench yet. In a separate round of 10 Excel and Microsoft 365 prompts on 2026-10-20, Claude Opus 5.5, Claude Sonnet 5, Claude Fable 5.1 and GPT-6 Astra answered in text through a command-line API harness, while Gemini 4 Argon used Google’s Antigravity CLI with a tool-less agent; none used consumer apps, so app results may differ. Formulas were judged on their logic and stated result, not executed in Excel, and this was not Copilot in Excel or Microsoft 365; the tested prompts are listed on our Excel tool page. The documented limits below are separate from general verification advice.

• Retired function: starting September 14, 2026, the COPILOT worksheet function is unavailable. It was a preview limited to Frontier and Microsoft 365 Insider. Previously calculated results remain cached, but recalculating COPILOT cells return #NAME?. Microsoft directs users to the pane instead.
• Direct editing: edit mode changes the workbook. Choose plan mode when you need prior review, and use Stop if live changes diverge from your intent.
• Access and platform limits: a missing icon may reflect subscription or organizational restrictions; mobile modes differ as listed above.
• Separate web handling: web search queries go to Bing under separate data-handling practices. Review that path before including confidential information in a web-search request.

For general verification, name the source sheet and range explicitly. Compare a generated formula with a hand-calculated control value, inspect its references, and reconcile PivotTable totals to the source. Recompute percentages and check missing values, units and classifications before sharing. These are precautions, not observed Copilot error rates.

Is my data safe in Copilot in Excel?

Microsoft documents enterprise protections for organizations, but those statements do not establish suitability for every workbook or plan. Consumer data terms have not been verified for this page.

The enterprise data protection page, checked 2026-10-20, says Microsoft 365 Copilot is now named Microsoft Copilot, alongside Copilot Chat. For organizations, it states:

• The Microsoft Products and Services Data Protection Addendum (DPA) and Product Terms apply, with Microsoft acting as data processor.
• Prompts and responses receive the same contractual protections as Exchange email and SharePoint files, with encryption at rest and in transit.
• Copilot respects organizational permissions, sensitivity labels, retention policies and audit.
• Prompts, responses and Microsoft Graph data are not used to train foundation models.
• Web search queries go to Bing, with separate handling and Microsoft acting as an independent controller.

We have not verified consumer-plan terms for retention, training, encryption or certifications. Read the actual plan’s privacy terms and professional confidentiality requirements before entering client, patient or employee information.

Model facts also need scope: in Copilot Cowork, Auto selects from models the organization enables; Claude Fable 5.1 requires the Anthropic subprocessor to be enabled, and GPT 5.5 (Frontier) is hosted in Azure AI Foundry. These facts do not identify which model processes a particular Excel request.

Limits: this is not legal, medical or tax advice. Have a licensed professional in your jurisdiction check applicable confidentiality and disclosure obligations. Under US HIPAA Privacy Rule 45 CFR 164.502(e), a covered entity may disclose PHI to a business associate only with satisfactory assurance through a business associate agreement that it will be safeguarded; an AI vendor receiving PHI is a business associate. Ask your compliance officer to verify the applicable agreement rather than assuming your plan qualifies.

FAQ