Copilot's Agent Mode in Word, Excel, and PowerPoint: What Changed
For the first couple of years Copilot lived in Word, Excel, and PowerPoint, it worked roughly the way autocomplete does: you asked, it suggested one chunk of text or one formula, and you clicked accept or reject. It never touched more than what you'd explicitly asked about, and it never touched it twice in a row without you asking again.
That changed in 2026. Agent mode reached general availability in Word, Excel, and PowerPoint on April 22, 2026, and the apps now open Copilot in an editing mode by default (Excel, for example, offers Allow editing, Plan, and Chat only, and starts in the editing one). It's also not locked to a business Copilot seat: Microsoft 365 Personal, Family, and Premium subscribers get it too, with consumer AI credit limits applying, while what you see in a work account depends on your license and your admin's settings. The practical difference is that Copilot now opens the document, plans a sequence of actions, and executes them, one after another, without waiting for you to approve each individual keystroke. You give it a goal instead of a single edit, and it works through the steps to get there.
Note
If you haven't used Copilot in Office apps at all yet, the Complete Beginner's Guide to Copilot covers account setup and the basics this article assumes.
What "agent" actually means here
The word gets used loosely across the industry, so it's worth being specific about what it means inside Word, Excel, and PowerPoint. It's the same Copilot, reaching into the same three apps, just with a different mode of working once it's there:
Copilot
Word
Excel
PowerPoint
Agent mode means three things happen that didn't happen in the old suggestion-only version:
Copilot can take more than one action per request. Ask it to restructure a document and it might add headings, reorder sections, insert a table, and adjust formatting, all from a single prompt, instead of you asking for each of those separately.
Copilot can act on the whole file, not just the selected paragraph or cell. It reads enough of the document, sheet, or deck to understand what's already there before deciding what to change.
Copilot shows what it's doing as it works, step by step, so you can follow the sequence of actions instead of just seeing a final result and wondering how it got there.
Old Copilot
SuggestYou ask for one change. Copilot proposes it. You accept or reject that one thing.
Agent mode
ActYou describe a goal. Copilot plans several actions and makes them directly in the file.
You
ReviewYou check the steps it took, keep what's right, and undo or correct any step that isn't.
A real example in each app
Agent mode looks different depending on what the file is, so it helps to see it in each app rather than as an abstract description.
In Word, say you have a page of raw meeting notes: bullet points with no structure, a few action items buried in the middle, some dates that don't line up chronologically.
Turn these meeting notes into a two-page project status memo. Add a header for each of these sections: Summary, Decisions Made, Open Questions, and Next Steps. Pull anything that sounds like an unresolved question into the Open Questions section and bold it. Keep my original wording where you can.
”Under the old model, you'd have gotten one rewritten paragraph and had to ask again for headers, again for the reorganization, and again for the bolding. Agent mode does all of it in one pass: it adds the four headings, moves content into the section it belongs in, finds the sentences that read as open questions, and bolds them, then shows you a summary of what changed.
In Excel, say you've got a messy expense export: one "Category" column that actually mixes categories and subcategories, a date column, and no summary anywhere. Here's a sample of what the sheet looks like before you ask for anything:
Expense export, before agent mode (illustrated)
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Date | Vendor | Category | Amount |
| 2 | 2026-01-06 | Harborview Print Shop | Office: Printing | $340.00 |
| 3 | 2026-01-14 | Continental Air | Travel: Flights | $612.40 |
| 4 | 2026-01-29 | Overlook Catering | Meals: Client | $188.25 |
| 5 | 2026-02-11 | Continental Air | Travel: Flights | $540.00 |
| 6 | 2026-03-04 | Harborview Print Shop | Office: Printing | $275.50 |
| 7 | 2026-03-18 | Overlook Catering | Meals: Client | $96.00 |
Split the Category column into two columns, Category and Subcategory, based on the text before and after the colon. Add a Month column pulled from the Date column. Then build a pivot table summarizing total spend by Month and Category on a new sheet.
”Excel
Agent mode's step list, illustrated
Split Category into two columns, Category and Subcategory, using the text before and after the colon in each row. Added a Month column derived from Date. Created a new sheet named Spend Summary. Built a pivot table on that sheet totaling spend by Month and Category. Four steps, one request, each one listed here so you can check it before you keep working.
That step list matters as much as the result. Here's the sheet agent mode actually produced, with the split columns and the Month column in place:
Category split, Month column added, after agent mode (illustrated)
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Date | Vendor | Category | Subcategory | Month | Amount |
| 2 | 2026-01-06 | Harborview Print Shop | Office | Printing | Jan | $340.00 |
| 3 | 2026-01-14 | Continental Air | Travel | Flights | Jan | $612.40 |
| 4 | 2026-01-29 | Overlook Catering | Meals | Client | Jan | $188.25 |
| 5 | 2026-02-11 | Continental Air | Travel | Flights | Feb | $540.00 |
| 6 | 2026-03-04 | Harborview Print Shop | Office | Printing | Mar | $275.50 |
| 7 | 2026-03-18 | Overlook Catering | Meals | Client | Mar | $96.00 |
New sheet, Spend Summary: pivot table by Month and Category (illustrated)
| A | B | C | |
|---|---|---|---|
| 1 | Month | Category | Total |
| 2 | Jan | Office | $340.00 |
| 3 | Jan | Travel | $612.40 |
| 4 | Jan | Meals | $188.25 |
| 5 | Feb | Travel | $540.00 |
| 6 | Mar | Office | $275.50 |
| 7 | Mar | Meals | $96.00 |
You didn't specify the formula syntax for splitting text on a colon, and you didn't tell it the pivot table needed the Month and Category columns to exist first. It figured out both. That second part is the actual difference agent mode makes here, not just doing three things instead of one. A single-turn version of Copilot could have handled the column split alone, then stopped and waited for you to ask for the Month column, then stopped again and waited for you to ask for the pivot table. Agent mode planned the dependency between those steps itself: the pivot table can't be built until Month and Category both exist, so it sequenced the work in that order and only built the summary once the columns it depends on were actually there, not just assumed to be. That's what "checks its own work" means in practice here. It isn't running a fixed script; each step is built on what the previous step actually produced in the sheet.
In PowerPoint, say a colleague handed you a bloated 22-slide deck that needs to become a tight executive version.
Condense this into 8 slides organized by theme instead of by date. Combine slides that cover the same topic, cut anything that's just a status update with no decision attached, and apply our template's title slide style to the new title slide.
”Agent mode deletes and merges slides, reorders the remaining ones by theme, and reformats the title slide, all without you touching each slide individually.
Staying in control of it
Giving Copilot the ability to make several changes at once is useful, and it's also the exact reason you can't treat its output the way you treated the old single-suggestion version. A wrong suggestion used to cost you one rejected paragraph. A wrong multi-step action can cost you a restructured document you now have to untangle.
- 1
Read the steps before you keep working
All three apps show you what agent mode is doing, usually as a short list of the steps it took. Read it the way you'd read a colleague's summary of edits they made to your file while you were away from your desk.
- 2
Fix the one bad step, not the whole thing
You don't have to treat the result as all or nothing. Use Undo, or tell Copilot which specific change to reverse or redo, so you keep the parts that worked and fix the one step that didn't, instead of losing everything and starting over. Exactly how granular undo gets varies by app and version, so test it on a throwaway file first.
- 3
Work in a copy for anything sensitive or final
For a document that's about to be sent, signed, or filed, duplicate it first and let agent mode work on the copy. This costs you a few seconds and removes any risk of losing the original structure if a multi-step change goes further than you meant.
- 4
Verify anything with numbers or legal language by hand
Agent mode is confident by default, whether or not it should be. A formula it wrote in Excel, or a policy statement it drafted in Word, still needs a human to check it's actually correct, not just plausible.
The mistake that catches people off guard
Assuming a multi-step action is all-or-nothing. It isn't. If four out of five changes were right, don't reject the whole batch to fix the fifth. Undo or redo just the one step that's wrong and keep the rest.
When to still do it the old way
Agent mode is built for changes that span a document, sheet, or deck. It's not always the faster path for a small, contained edit. If you just need one sentence rewritten or one cell's formula corrected, asking Copilot to fix that one thing directly is still faster and easier to verify than framing it as a multi-step goal. Save agent mode for the requests that genuinely touch more than one part of the file at once: restructuring, reformatting across many slides or cells, or building something new (a pivot table, a section-by-section rewrite) that didn't exist yet.
The apps that actually put this to work, drafting a document from an outline in Word, analyzing a spreadsheet in Excel, and building a deck in PowerPoint, each go into their own specific prompts and pitfalls in more depth elsewhere on this site.
Official sources
- Copilot's agentic capabilities in Word, Excel, and PowerPoint are generally available
- Get started with Copilot in Excel
- AI credits and limits for Microsoft 365 subscriptions
Checked on September 21, 2026. Features, plans and names change often, so the vendor's own pages are the final word.