Microsoft Copilot Prompts for Word, Excel and Outlook That Hold Up in 2026

You open a Word document, type "make this better" into Copilot, and get back something smoother and emptier. The prompt is the problem, but so is the product: Microsoft's Copilot setup in late 2026 has several tiers, a function that no longer exists, and rules about what data it can see. Most guides online were written before those changed.

This post covers the Microsoft Copilot prompts for Word, Excel and Outlook that give you usable first drafts, plus the licensing and data caveats that explain why a prompt works for a colleague and not for you. Everything product-related was checked against Microsoft's own pages on 2026-10-08. The prompts themselves are untested templates. I don't have a Copilot licence in my working environment, so I haven't run them. Test each on a harmless document first.

Which Copilot do you actually have?

Microsoft's Copilot overview (Microsoft Learn, updated 2026-10-01) describes three experiences, and prompt advice means nothing until you know which one is yours:

Microsoft also says chat experiences vary by tenant configuration and licence, and that "standard access" depends on service capacity and can vary through the day. Two other things from that page: the "Microsoft 365 Copilot Chat" app has been renamed Microsoft Copilot Chat (URL copilot.cloud.microsoft), and Anthropic models are available only in applicable licensed experiences, not for everyone by default.

Why this matters for prompting: on the Basic tiers, "summarise my last week of emails about Project X" can't work, because it has no automatic access to your mail. Paste the content in or reference a file. On Premium, name the file or meeting you mean, or it may pick the wrong one.

I could not find a single plain-English page that maps every licence to every app feature. If your menu looks different from the descriptions here, ask your admin which tier you're on. Don't assume it's your prompt.

How do I prompt Copilot in Word?

Microsoft's page "Draft and add content with Copilot in Word" lists what it does: draft from a prompt, outline, notes or reference files; keep, discard, regenerate or refine; reuse a template's format; add sections, tables or checklists; rewrite selected text; turn text into a table; and generate content with citations. It tells you to include topic, audience, tone, format and length, and to type / to pick a specific file as a source.

That last list is a prompt skeleton. Untested template:

Draft a [document type] for [audience].
Purpose: [what the reader should do or decide after reading].
Source: use only /[file name] and the notes below. If something isn't covered, mark it [CHECK] instead of filling it in.
Tone: [plain, direct, no marketing language].
Length: [about 400 words].
Structure: [heading list].
Notes:
[paste]

The [CHECK] line is the part most people skip. Microsoft's page itself says to verify facts, numbers, citations and names in anything Copilot produces. Giving it a visible way to say "I don't know" makes your review faster than hunting for plausible-sounding gaps.

For rewrites, select the passage and be specific about what's wrong:

Rewrite this paragraph for a finance director who has two minutes. Keep every number unchanged. Cut it by a third. Do not add claims.

"Keep every number unchanged" is worth the six words. Then compare the numbers yourself.

On reference-file limits, the sources I found disagree. One Microsoft mobile page says you can pick up to three files, while the desktop accessibility page says one at a time. The main Word page gives no count. Test in your version before building a workflow around three.

Two bad habits to drop. Don't ask for "a better version" with no direction, since it gets you blander prose. And don't paste a whole 40-page contract and ask for "key risks" unless a lawyer will read the contract anyway. For tone work on your own writing, how to prompt AI to sound human covers the editing pass.

How do I prompt Copilot in Excel?

First, a change that breaks older tutorials. Microsoft's COPILOT function page says that starting September 14, 2026, the =COPILOT() worksheet function is no longer available in Excel. It was a preview feature, offered through Microsoft's Insider and Frontier programs, so you only hit this if you tried it there. Existing results stay as cached values, then show #NAME? when the cell recalculates. Microsoft's replacement is the Copilot pane: describe the task in plain language.

If you have an old workbook with =COPILOT("Classify sentiment", B2:B100), you'll need to ask the pane to do the same classification into a new column, then convert to values once checked.

Second, your data has to be ready. From Microsoft's "Format data for Copilot in Excel" guidance (as summarised from search results; I couldn't fetch the page itself):

• Data must be an Excel table or a supported range.
• A range needs one header row, unique non-blank headers, consistent formatting, no subtotals, no empty rows or columns, no merged cells.
• To convert: select the cells, Home, Format as Table, tick "My table has headers".
• Tables up to 2 million cells; files in .xlsx, .xlsb or .xlsm on OneDrive or SharePoint; Strict Open XML is not supported.
• Editing requires Calculation Options set to Automatic.
• Changes are written to the workbook, so co-authors see them immediately.

The AutoSave requirement is contested. One source says Copilot works only with AutoSave on, another says a July 2026 update allows AutoSave off for cloud workbooks. If Copilot is greyed out, check that first.

Prompts for the pane that name what you want:

Using the Orders table: add a column "Days to ship" = Ship date minus Order date.
Flag rows where it's over 5 in a second column. Don't change any existing columns.
Then tell me the formula you used.

Summarise revenue by Region and Month from the Orders table as a pivot table on a new sheet.
Exclude rows where Status = "Cancelled". List any rows you excluded for missing values.

"Tell me the formula you used" matters. Then you can read it, test it on five rows, and keep it. The checking routine in ChatGPT Excel and Google Sheets formula prompts works unchanged here: write expected answers for five rows by hand, fill down, compare. The difference with Copilot in the pane is that it edits your sheet directly, so work on a copy until you trust it.

Microsoft's guidance for the old function still holds as a rule of thumb: use ordinary formulas like SUM or IF when you need accuracy or reproducibility, and don't rely on AI output for financial reporting, legal documents or other high-stakes work.

How do I prompt Copilot in Outlook?

Microsoft's support page on summarising threads confirms the basics. Open the conversation, choose Summarize in the "Summary by Copilot" box at the top (on iOS and Android, tap the Copilot icon in the toolbar). The summary can include numbered citations that jump to the related emails. In new Outlook for Windows and Outlook on the web you can also choose "Summarize a file" for PDF, PowerPoint or Word attachments. The page doesn't state thread-length limits or licensing.

After the summary, ask follow-up questions about specific details, which Microsoft's training module also describes. Questions that earn their keep:

Who has been asked to do something in this thread and hasn't replied? Quote the message.

List every date mentioned and what it refers to. Mark any that conflict.

What does the sender actually want from me, in one sentence?

Drafting replies: I could only confirm that Microsoft has pages titled "Draft an email message with Copilot in Outlook" and "Email coaching with Copilot in Outlook". I didn't read their contents, so I won't describe coaching beyond what the overview says (tone, clarity and sentiment tips). Treat a draft as a draft. Give it your decision and facts, never ask it to decide for you:

Reply to Priya. My decision: we keep the 14 November date, conditional on QA. 
Include: the condition, that Marcus sends the SOW by Friday, and a request for her to confirm the refund-flow owner.
Three short paragraphs, no pleasantries beyond one line. Don't add commitments I haven't listed.

If you receive a lot of email, the broader routines in AI email automation prompts are model-agnostic and pair well with this.

What are the limits and gotchas?

• It follows your permissions. Microsoft says access is scoped by user permissions. That's good for security and a reminder that Copilot may surface a file you'd forgotten you could see. Don't ask for summaries of documents you shouldn't be reading.
• Enterprise data protection. The overview says all three tiers are protected by Enterprise Data Protection when you sign in with a Microsoft Entra account. Signing in with a personal account is a different path, so check which one you're on before putting company data in.
• Sensitivity labels block some features. An older version of the COPILOT function page noted it wouldn't calculate in workbooks labelled Confidential. I can't confirm how that applies to the Copilot pane. Check with your admin.
• Model choice. Microsoft's Word page says that depending on your subscription you can pick models such as Claude Sonnet or Claude Opus, or leave it on Auto. Auto is fine unless you have a reason.
• Rollouts are uneven. Microsoft says some experiences roll out gradually depending on licence, tenant settings, app version and platform. A feature in a tutorial can be missing from your menu for weeks.

A short checklist before you send anything Copilot wrote

1. Every number: traced to a source you can name.
2. Every name and date: checked, not skimmed.
3. Anything marked [CHECK]: resolved.
4. Excel changes: tested on five rows, on a copy.
5. Tone: would you say this to the person's face?

For a broader set of reusable prompts you can adapt for other tools, see prompt templates I actually use.