How to Use Excel Copilot Agent Mode

What Excel Copilot Agent Mode actually does

Agent Mode is a step up from the standard Copilot chat in Excel. Instead of answering one question at a time, it takes a high-level goal, breaks it into a multi-step plan, and executes each step directly in your workbook. It creates formulas, inserts charts, builds PivotTables, applies conditional formatting, and restructures data on its own. After each step, it reviews the result and adjusts if something looks off.

This is useful when you need to go from raw data to a finished report or dashboard without manually wiring every piece together. Think of it as handing a brief to an analyst who works inside your spreadsheet in real time.

Who can access Agent Mode

Agent Mode requires one of the following subscriptions: Microsoft 365 Personal or Family with an AI credits plan, Microsoft 365 Premium, a commercial Microsoft 365 Copilot license, or a Copilot Chat-eligible Microsoft 365 business or enterprise subscription. It works in Excel for the web, Windows, and Mac. Language support covers English, Spanish, Japanese, French, German, Portuguese, and over 20 additional languages.

One important prerequisite: your workbook must use Automatic calculation mode. If it is set to Manual, Agent Mode will not activate. You can check this under Formulas > Calculation Options.

How to open Agent Mode

The quickest way to start is to open a workbook in Excel for the web or desktop and select Home > Copilot from the ribbon. When the Copilot pane opens, editing mode is on by default. If you are in Copilot Chat instead, open the Tools menu inside the pane and select Edit with Copilot.

You can also create a fresh workbook by navigating to excel.new in your browser, which drops you straight into a blank workbook with Copilot ready.

Writing effective prompts

Agent Mode works best when you describe the outcome you want rather than the individual steps. A prompt like "build a loan calculator that computes monthly payments based on loan amount, annual interest rate, and term in years" gives Copilot enough context to plan and execute the entire task.

Here are prompt patterns that produce reliable results:

Financial modeling. "Create an annual financial close report with product line breakdowns and year-over-year variance analysis." Copilot will set up tables for each product line, add formulas for variance calculations, and format the output with headers and totals.

Data reshaping. "Merge Sheet1 and Sheet2 on the Customer ID column, then create a summary table showing total revenue per region with a bar chart." This triggers a multi-step plan: matching rows, aggregating values, inserting a chart, and formatting.

Budget tracking. "Build a household budget tracker with categories for housing, food, transport, and utilities. Add conditional formatting to highlight any category that exceeds its monthly limit." Copilot generates the structure, applies data validation for categories, and sets up the formatting rules.

Data cleanup. "Standardize the date formats in column B to YYYY-MM-DD, remove duplicate rows based on columns A and C, and flag any missing values in column D with a red fill." This is where Agent Mode saves the most manual effort because it chains multiple cleanup operations into a single pass.

Choosing the right AI model

The March 2026 update introduced model selection inside Copilot. You can now pick between three specialized modes through Copilot settings:

The Analytical model emphasizes statistical functions, forecasting, and data validation. Use it when your task involves financial projections, trend analysis, or data quality checks.

The Operational model focuses on workflow automation, template creation, and repetitive task elimination. Choose this for building reusable report templates or automating recurring data imports.

The Creative model assists with visualization design, formatting, and generating narrative summaries from data. It is the better choice when you need dashboards or presentation-ready charts.

In Agent Mode specifically, you may also see options to select between different underlying AI providers, with an Auto mode that lets Copilot choose the best fit for your prompt. For most data analysis tasks, the Analytical model or Auto mode will produce the best results.

Watching Agent Mode work

After you submit a prompt, the Copilot pane displays a step-by-step reasoning trace. You can watch it plan, execute, and review each action. If something goes wrong partway through, you can press the Stop button to pause execution. Every change Copilot makes is tracked through Excel's version history, so you can undo individual steps or revert to a prior version if needed.

For complex requests, Agent Mode may take a few minutes to finish. This is normal. The pane updates in real time so you can see progress without guessing.

What Agent Mode cannot do

There are clear boundaries worth knowing before you rely on it. Agent Mode cannot access other files, emails, or enterprise data sources. It only works with the data already in your current workbook. It does not support external tool integrations or enterprise search. It cannot operate in Manual calculation mode. And it is not designed for simple one-step tasks like inserting a single chart; for those, the standard Recommended Charts or PivotTables features are faster.

Sensitive or shared files deserve extra caution. Agent Mode edits your workbook directly, so review changes carefully in collaborative environments. Use the feedback buttons (thumbs up and down) in the Copilot pane to help Microsoft improve accuracy over time.

Practical example: sales report from raw data

Suppose you have a workbook with 2,000 rows of sales transactions containing columns for date, product, region, quantity, and unit price. Here is a prompt that turns that into a finished report:

"Calculate total revenue (quantity times unit price) for each row. Then create a PivotTable summarizing revenue by region and product. Add a clustered bar chart for the top five products by total revenue. Format the PivotTable with currency formatting and bold headers."

Agent Mode will add a Revenue column with the multiplication formula, generate the PivotTable on a new sheet, insert the chart, and apply formatting. The entire process takes roughly 60 to 90 seconds depending on data size.

Tips for better results

Start with well-structured data. Agent Mode performs best when your data has clear column headers and consistent formatting. If your source data is messy, run a cleanup prompt first before asking for analysis.

Be specific about output format. Saying "with a bar chart" or "formatted as a table with totals" gives Copilot concrete targets. Vague prompts like "analyze this data" tend to produce generic summaries.

Break very large tasks into two or three prompts. While Agent Mode handles multi-step work well, a single prompt that asks for data cleaning, three different analyses, and a formatted dashboard may produce better results as two or three sequential requests.

If you work with data that needs to go from a raw file to a finished visual without writing formulas or code, VSLZ handles that workflow from a single upload with no configuration needed.

What to expect going forward

Microsoft is actively expanding Agent Mode's capabilities. The March 2026 update added Work IQ editing suggestions, model selection, and Office Scripts integration where you can describe automations in plain English and Copilot generates the TypeScript code. Future updates are expected to add cross-file data access and deeper enterprise search integration.

For now, Agent Mode is the most capable no-code data analysis tool inside Excel. It bridges the gap between knowing what you want from your data and knowing how to build it manually.