Copilot Agent Mode Reaches Excel on Desktop and Mac: Stop Copying Output Into Cells

What you'll learn in this article:

• What changed when Agent Mode reached Excel on Desktop and Mac this January
• The difference between Copilot suggesting an analysis and Copilot building it in the cells
• A complete Agent Mode prompt that turns raw data into a finished report
• The verification step that keeps an agent-built spreadsheet trustworthy
• Where this fits with the other January Copilot updates (voice memory, admin readiness)

For two years, Copilot in Excel has been a helpful assistant that mostly told you what to do. Ask it to analyze your data and it would describe the pivot table you should build, the formula you should write, the chart you should add. Then you would go and do all of that by hand. The intelligence was there; the hands were yours.

Microsoft's January 2026 Copilot update changed that for Excel. Agent Mode, which had already reached Word, rolled out to Excel on Desktop and Mac. In Agent Mode, Copilot takes multi-step actions directly in the worksheet: it cleans the data, builds the pivot, writes the formulas, and inserts the chart, reasoning through each change while you stay in control. PowerPoint follows in February.

The shift is from advice to action. The afternoon you used to spend turning a raw export into a formatted report becomes under an hour, because the part that took the time (the actual building) now happens inside the file. For finance and operations staff who live in Excel, this is the most concrete time saving in the January wave.

What Agent Mode Does in Excel

Agent Mode is a distinct mode within Copilot, separate from the normal chat sidebar. The difference is what it is allowed to do.

In the standard Copilot sidebar, you ask a question and get a written answer or a suggested step. In Agent Mode, Copilot takes app-native actions in the open workbook. It can clean and reformat data, build pivot tables, write and insert formulas, restructure tables, and add charts, executing a multi-step request from start to finish while showing its reasoning as it goes.

The key word from Microsoft's description is "alongside." Agent Mode works alongside you. It is not a black box that hands back a finished file with no explanation. It makes changes to the live worksheet and explains the steps so you can verify each one. You stay in control and can redirect it mid-task.

The requirement is a Microsoft 365 Copilot license. Agent Mode in Excel is rolling out on Desktop and Mac through January. Word already has it. PowerPoint arrives in February.

From Raw Export to Finished Report: The Complete Prompt

The way to get value from Agent Mode is to hand it the whole job at once, not one step at a time. Describe the full outcome and let it execute. Here is a complete, reusable prompt.

Excel Agent Mode Report Prompt

In Agent Mode, work in this worksheet. Do the following steps in order and explain each one as you make it so I can verify: 1. Clean the data: trim extra spaces, fix inconsistent date formats to YYYY-MM-DD, and remove duplicate rows. 2. Build a pivot summary of [metric, e.g. revenue] by [dimension, e.g. region]. 3. Add a column showing month-over-month change as a percentage. 4. Insert a bar chart of the top 5 [dimension] by [metric]. 5. Format the summary table with bold headers and currency formatting on the value columns. Do not delete the original raw data. Build the summary on a new tab named "Report."

Drop your raw export into a sheet, paste this in Agent Mode with your real metric and dimension filled in, and Copilot builds the report on a fresh tab while preserving your source data. The instruction to keep the raw data and work on a new tab is deliberate; it means a mistake never destroys your source.

The Verification Step You Cannot Skip

Because Agent Mode acts on the live file, the one habit that keeps it trustworthy is verification. An agent that builds formulas can build a wrong formula, and a wrong formula in a report you send upward is worse than no report.

After Agent Mode finishes, do three checks before you trust the output:

• Spot-check a total. Pick one number in the summary (a regional total, a monthly figure) and verify it against the raw data manually. If it matches, the aggregation logic is sound.
• Read one formula. Click into one of the calculated cells and read the formula Copilot wrote. Confirm it references the right range and does what you asked. This catches off-by-one range errors.
• Sanity-check the chart. Confirm the chart shows what the title claims and that the top 5 are actually the top 5, not the first 5 rows.

This takes about three minutes and it is the difference between Agent Mode being a time-saver and being a liability. The reason to keep the raw data on its own tab is so this verification is always possible.

How This Fits the Rest of the January Copilot Wave

Agent Mode in Excel is the headline, but it shipped alongside two other January updates worth knowing.

Copilot voice now references memory. In the Microsoft 365 Copilot app, voice chats can draw on the memories stored in your personalization settings, so spoken requests get more relevant, contextual answers. For a leader who uses voice between meetings, this means Copilot remembers your projects and preferences without re-explaining them.

A new admin readiness page. For anyone responsible for rolling Copilot out across a team, the Microsoft 365 admin center added a Copilot readiness page that organizes recommended settings into deployment essentials, end-user experience, and data security. Microsoft Purview is also now integrated into the admin center for oversharing visibility. If you are the person who decides how Copilot is deployed, this is where to start.

Together the wave moves Copilot from a sidebar assistant toward an agent that does the work, with the governance to deploy it responsibly.

Action Steps Summary

• Confirm Agent Mode in Excel: On Desktop or Mac with a Microsoft 365 Copilot license, open a workbook, launch Copilot from the ribbon, and switch to Agent Mode. If it is not there yet, the January rollout is still reaching your tenant.
• Hand it the whole report: Use the Excel Agent Mode report prompt above. Fill in your real metric and dimension and let it execute every step in one pass.
• Protect the source data: Always instruct Agent Mode to keep the raw data and build the summary on a new tab. A mistake then never destroys your source.
• Run the three verification checks: Spot-check a total, read one formula, sanity-check the chart. Three minutes that keep an agent-built report trustworthy.
• Set up the admin readiness page: If you own Copilot deployment, use the new readiness page and Purview integration in the Microsoft 365 admin center to roll it out with the right data-security settings.