Microsoft Copilot

How to Use Copilot Agent Mode in Word, Excel, and PowerPoint: Step-by-Step Tutorial (2026)

By Sagnik Bhattacharya 24 Apr 2026 11 min read

Coding Liquids blog cover featuring Sagnik Bhattacharya for How to Use Copilot Agent Mode in Word, Excel, and PowerPoint, showing the Copilot Agent Mode panel across Microsoft 365 apps.

On 22 April 2026, Microsoft announced that Copilot's agentic capabilities in Word, Excel, and PowerPoint are generally available — and, importantly, now the default Copilot experience for everyone on Microsoft 365 Copilot, Microsoft 365 Premium, and Microsoft 365 Personal and Family plans. The feature is called Agent Mode. Instead of suggesting text you paste in yourself, it takes multi-step actions directly inside the file — drafting, restructuring, applying your brand template, adding formulas, rebuilding charts, updating a deck with fresh numbers.

This tutorial is written for someone who has never used Agent Mode before. By the end of it you will have turned it on, run your first agent task in all three apps, learned the prompt pattern that produces usable output on the first try, understood what Agent Mode still cannot do, and fixed the five gotchas that stop most first sessions. If you want the deeper Excel-only setup, I have a separate guide on Agent Mode in Excel and a comparison of Analyst vs Agent Mode vs Copilot Chat — this one is the cross-app beginner path.

I teach Flutter and Excel with AI — explore my courses if you want structured learning.

Prerequisites

Before you open Word, Excel, or PowerPoint, check the following four things. Each one is a common reason Agent Mode silently refuses to engage.

An eligible paid plan. Agent Mode requires Microsoft 365 Copilot (the business add-on), Microsoft 365 Premium, or Microsoft 365 Personal and Family. The free web versions of Word, Excel, and PowerPoint do not get it. Your plan is visible under File → Account in any of the three desktop apps.
An updated app. Agent Mode rolled out with Microsoft 365 Current Channel updates during March–April 2026. If your Word, Excel, or PowerPoint is more than a month out of date, update through File → Account → Update Options → Update Now. On Mac, update through the Microsoft AutoUpdate utility.
File saved to OneDrive, OneDrive for Business, or SharePoint. Agent Mode needs a cloud-backed file to perform multi-step changes with version history. A file saved only to your local desktop will surface a "Move to OneDrive" banner and refuse to engage until you move it.
For Excel only: your data should be formatted as an Excel Table (select the range and press Ctrl+T, or ⌘+T on Mac). Agent Mode will not build formulas, sort, or chart against an unformatted range — it reads the table structure to understand your columns.

Step 1: Turn on Agent Mode (the path is the same in all three apps)

The single most useful thing to learn first is that the UI path to Agent Mode is identical in Word, Excel, and PowerPoint. Once you know it, you know it everywhere.

Open any document, workbook, or presentation that is already saved to OneDrive or SharePoint.
Click the Copilot icon in the bottom-right corner of the window. This opens the Copilot pane on the right.
At the bottom of the Copilot pane you will see an input box. Click the Add Content button inside that box (it looks like a small "+").
A drop-down menu appears. Click Agent Mode at the top of the menu.
The pane switches styling — the header now reads "Agent Mode" and the input box gets a brief instructional placeholder ("Tell the agent what to do…"). You are now in Agent Mode.

If the "Agent Mode" option is missing from the drop-down, you hit one of the four prerequisites above — most commonly the plan tier or the file location. Work through the prerequisites list again before trying anything else.

Step 2: Use Agent Mode in Word — draft, rewrite, restructure, retone

Word is the gentlest app to learn Agent Mode in because the edits are visible — you can watch text appear and sections move. Microsoft's framing is that Agent Mode helps you go from a blank page to a polished document faster, drafting, rewriting, restructuring, and applying the right tone for your audience. In practice, the four actions you will use most are these:

Draft a full document from a brief

Paste a short brief and let the agent produce a full first draft. A prompt that works consistently on the first try:

Draft a 1,200-word product launch memo for our new feature, Instant
Insights, aimed at internal sales and customer success teams. Start
with a one-paragraph executive summary. Then cover: what Instant
Insights does in 2 sentences, the three customer problems it solves,
the target customer (mid-market SaaS, 200-2,000 employees), the
messaging we're testing in the launch campaign, a rollout timeline
with three milestones, and a single call-to-action for reps to book
a training session this Thursday. Tone: clear, specific, no hype.

Agent Mode writes the memo inline — headings, paragraphs, and bullet lists directly in the document. It does not paste into a chat for you to copy across. You review in place, then tell it what to change.

Rewrite a selection

Select a paragraph on the page, open Agent Mode, and type a rewrite instruction — "make this two sentences shorter and lead with the outcome, not the feature", or "rewrite this for a non-technical reader, keep the numbers". The agent replaces the selection in place and leaves a change-tracking marker you can accept or reject.

Restructure the whole document

This is the action that most distinguishes Agent Mode from older Copilot. A prompt like "move the pricing section to immediately after the problem section, and cut the competitive landscape section to three bullet points" produces a real restructure — headings moved, content cut, surrounding transitions re-written so the document still flows. This used to take an afternoon of manual rework.

Retone for a different audience

"Rewrite the entire document in the voice of a technical architect explaining the same thing to a principal engineer" or "soften the tone so this can go directly to an enterprise customer". Agent Mode rewrites in place while preserving the structure, headings, and data. This is useful when one source document has to produce three audience variants.

Step 3: Use Agent Mode in Excel — explore, analyse, act on the workbook

In Excel, Agent Mode is dramatically more capable than Copilot Chat because it can make changes — not just describe them. Microsoft's phrasing is that Agent Mode helps you explore data, build and explain analysis, and make changes directly in your workbook, from formulas to tables to visuals. The public numbers Microsoft published at GA are striking: Excel engagement jumped 67%, satisfaction rose 65%, and new user retention grew 50% once Agent Mode became the default.

Explore a new dataset

Open a workbook where you have pasted or imported a table you have never used before. Select the table, open Agent Mode, and type:

Explore this data. Summarise what each column is, flag anything that
looks like a quality issue (nulls, duplicates, outliers, obvious
miscategorisations), and suggest three analyses this dataset
supports.

Agent Mode reads the table and writes a summary into the Copilot pane (column-by-column breakdown, data quality flags, suggested analyses). It does not yet modify the workbook on this prompt — this first step is analysis, not action. But you can follow up with any of its suggestions and it will execute them.

Build analysis directly in the workbook

"Add a column that calculates year-over-year growth per region, then group the rows by region and sort by growth descending. Highlight the top three rows in warm orange (#E8852E)." Agent Mode writes the formula, applies the table grouping, sorts, and formats — all in the actual workbook, with every step listed in the Copilot pane so you can review or revert. If you want more background on this specific action, I have a longer guide at Agent Mode in Excel: What It Does, What It Can't, and Who Should Use It.

Explain an existing formula

Click a cell with a nested formula, then ask Agent Mode "explain this formula step by step, then suggest a simpler version if one exists". You get a plain-English breakdown plus a proposed rewrite using modern functions (LAMBDA, LET, GROUPBY). Accept the rewrite and the agent applies it to the cell. For tricky formulas, the COPILOT function can embed Agent Mode into the formula bar itself.

Rebuild charts and visuals

"Rebuild this chart as a stacked bar grouped by quarter, with our brand orange for growth and a muted grey for everything else. Add data labels on the top three values only." Agent Mode rebuilds the chart object in place — old chart removed, new chart inserted at the same position, same size, connected to the same data range. The full background on Copilot's chart behaviour sits in my Create charts with Copilot in Excel tutorial.

Step 4: Use Agent Mode in PowerPoint — build, update, and stay on template

PowerPoint is where Agent Mode saves the most time for most people, because decks are the thing that rot fastest. A deck built last quarter probably has stale numbers, outdated team slides, and a customer logo that has since churned. Agent Mode can update a deck in place while respecting your corporate template and brand styling.

Build a deck from a prompt

Start a new presentation based on your company template, then open Agent Mode and say:

Create a 12-slide board update deck for Q1 2026. Slide order: title
(with our Q1 tagline), executive summary, revenue and growth
dashboard, three customer wins with logos, product release highlights
(three features), team growth numbers, top three risks, the quarterly
asks for the board, and a thank-you close. Use the attached
Q1_metrics.xlsx for all numbers. Keep the corporate template — do
not change fonts, colours, or master slides.

Agent Mode creates the slides in order, pulls numbers from the referenced Excel workbook, inserts real charts (not screenshots), and stays inside the slide master. Attach the XLSX source through the Add Content drop-down in the Copilot pane — you will see it listed as a referenced file while the agent works.

Update an old deck with this week's numbers

This is the single highest-leverage use of Agent Mode in PowerPoint. Open last quarter's deck and say "update every number, chart, and dated reference in this deck using the data in Q2_metrics.xlsx. Keep the same slide order, headings, and template. Flag any slide where the numbers have moved more than 20% so I can rewrite the commentary." Agent Mode goes slide by slide, swapping numbers, rebuilding charts, updating quarter labels, and listing the flagged slides at the end. You still write the commentary on slides where the story shifted — but the grunt work is gone.

Restyle a deck to a different template

"Re-apply our 2026 template to this deck. Keep all content, move any content that does not fit the new layout into speaker notes so I do not lose it, and preserve the slide order." Agent Mode maps old placeholders to new, migrates bullets, and stashes any orphaned content in the notes pane — so nothing is silently dropped.

Step 5: Four prompt patterns that work in all three apps

Prompts are the steering wheel. After testing dozens since GA, four patterns consistently produce usable first drafts regardless of which app you are in.

The brief-and-audience pattern. "Produce <deliverable> for <audience>. The key message is <one sentence>. Tone: <two adjectives>. Constraints: <length, template, brand tokens>." Used as the opening instruction for any new draft in Word or PowerPoint.
The restructure pattern. "Move <X> to <position>. Cut <Y>. Expand <Z> to cover <list>. Keep everything else." Works identically in Word (sections) and PowerPoint (slides).
The data-driven update pattern. "Update every <chart / number / quote> in <this file> using <attached source>. Keep <headings / layout / template>. Flag any slide/section where the delta is >X%." Works identically in Excel (recompute) and PowerPoint (restate).
The explain-then-act pattern. Ask for analysis first ("explain what is happening in this formula / section / chart"), read the explanation, then ask for the change ("OK, apply the simpler version / cut it to three bullets / rebuild with <variant>"). Splitting analysis from action is the best way to catch a wrong assumption before Agent Mode commits a change.

The common thread across all four patterns is specificity. Audience, tone, length, template, constraints. Vague prompts produce generic first drafts. Specific prompts produce first drafts you can actually ship.

Step 6: What Agent Mode still will not do

Agent Mode is genuinely impressive, but it has real limits. Pretending otherwise sets you up for a bad first session.

Cross-app orchestration from one prompt. You cannot today say "build the Q1 narrative in Word, the numbers in Excel, and the deck in PowerPoint all at once" from a single instruction. Agent Mode is scoped to the active file. Cross-app is on Microsoft's roadmap.
Truly custom brand accuracy. If your brand guidelines include precise typographic rules (specific line-height, optical kerning, brand-specific spacing rhythms), Agent Mode will not match them exactly. It respects the master slide and theme colours, which is 80% of most brand enforcement. The last 10-20% is still manual.
Live financial data. Agent Mode works against whatever you give it — an attached Excel workbook, a pasted table. It does not browse the live market or pull from your SaaS data sources automatically. Connect Power Query or an API-backed connector first, then run Agent Mode against the refreshed workbook. My AI + Power Query M code guide covers that piece.
Mobile parity. Agent Mode is generally available on Windows, Mac, and the web versions of each app. The mobile apps (iOS, Android) still route Copilot traffic through Chat. Use a mobile browser on m.office.com for Agent Mode on the go.
Accept-without-review is risky. Every Agent Mode action writes into your file. There is a clear undo path in the Copilot pane, but you can and should review changes before closing the file — especially formula and chart edits in Excel, where a subtle mis-reference can propagate silently. My review-AI-generated-formulas guide has the full checklist.

Troubleshooting the first-session gotchas

Most first-session pain resolves to one of five issues. Check them in this order.

"Agent Mode" is missing from the Add Content drop-down. The two common causes are plan tier and app version. Check File → Account: your plan must be Microsoft 365 Copilot, Microsoft 365 Premium, or Microsoft 365 Personal/Family. Then update the app through File → Account → Update Options → Update Now. Close and reopen the app after updating — the Copilot pane reads the capability list at launch, not at runtime.
"Move this file to OneDrive to use Agent Mode." Click File → Save As and pick OneDrive or OneDrive for Business as the location. If OneDrive is greyed out, open the OneDrive app in Windows (or Mac menu bar) and sign in with the same account your Microsoft 365 plan is attached to.
Excel: Agent Mode refuses to touch a range. Your data is probably not formatted as an Excel Table. Select the range, press Ctrl+T (or ⌘+T), confirm "my table has headers" if it does. Retry the prompt — the refusal disappears immediately. Full background in my format data for Copilot in Excel guide.
PowerPoint: Agent Mode changes fonts or colours that should be template-locked. Your template is probably not a true theme — it is styled slides rather than a proper slide master. Open View → Slide Master, confirm your colours and fonts are defined there, save as a .potx, and re-apply. Agent Mode honours the master but cannot read overrides on individual slides.
Agent Mode stops mid-task and asks for confirmation on every step. This is working as intended for higher-risk changes, but the confirm cadence is tuned in Copilot settings → Agent permissions. On Personal and Family plans you can move the slider to "Ask once at the start"; on business plans it may be controlled by your admin. If it is locked, your Microsoft 365 admin has set tighter guardrails — ask them before asking Microsoft support.

Frequently Asked Questions

Is Copilot Agent Mode free to use?

No. Agent Mode in Word, Excel, and PowerPoint requires a paid Microsoft plan — Microsoft 365 Copilot (business), Microsoft 365 Premium, or Microsoft 365 Personal and Family. Free Microsoft accounts and basic Microsoft 365 Personal without Premium cannot turn it on. If you already pay for any of those plans, Agent Mode is included at no extra cost and is now the default Copilot experience in Word, Excel, and PowerPoint as of 22 April 2026.

What is the difference between Copilot Chat and Agent Mode?

Copilot Chat is the side pane that answers questions, summarises content, and drafts text you then paste in yourself. Agent Mode is the multi-step, in-document actor — you give it a goal, and it edits the document directly: inserting sections, restructuring the deck, adding formulas, rebuilding charts, applying your brand template. Chat is for asking; Agent Mode is for doing. In Word, Excel, and PowerPoint, Agent Mode is now the default Copilot experience for eligible plans, but Chat remains available through the same pane. If you want the full comparison with the third option (Analyst), I have Analyst vs Agent Mode vs Copilot Chat.

Which apps and platforms support Agent Mode in 2026?

As of April 2026, Agent Mode is generally available in Word, Excel, and PowerPoint on Windows desktop, Mac desktop, and the web versions of each app (office.com). Feature parity across Windows, Mac, and web completed in January 2026. Mobile apps (Word, Excel, PowerPoint for iOS and Android) still route to Copilot Chat rather than Agent Mode — use the web app from a mobile browser if you need Agent Mode on the go.

Do my files need to be saved to OneDrive or SharePoint for Agent Mode to work?

Yes. Agent Mode needs your file stored in OneDrive, OneDrive for Business, or SharePoint so it can make multi-step changes, keep a version history, and reference your workspace. A local file saved only to your desktop will surface a banner asking you to move the file to OneDrive before Agent Mode will engage. For Excel specifically, data should also be formatted as an Excel Table (Ctrl+T) — unformatted ranges cause Agent Mode to refuse formula and chart actions.

Can Agent Mode work across Word, Excel, and PowerPoint at the same time?

Not from a single prompt today. Agent Mode is scoped to the file you have open — it can read other documents you reference (for example, an Excel workbook as a source for a PowerPoint update) but it executes changes in the active app only. Cross-app orchestration across Word, Excel, and PowerPoint from one instruction is on Microsoft's roadmap but not generally available as of April 2026. The practical pattern is to run Agent Mode three times: once in Excel to produce the numbers, once in Word to produce the narrative, once in PowerPoint to produce the deck that references both.