Free tools Windows power users keep installed
One-click scans. No signup required.
To get more consistent results from Copilot in Excel, put workbook-specific conventions on a visible .Rules worksheet, save personal preferences in Copilot’s Personalization settings, and use a skill for a repeatable multistep task. These settings have different scopes, so they work best together: tell Copilot what should travel with a file, what should follow your account, and what procedure it should reuse.
Choose the right place for each instruction
Use the scope that matches who needs the instruction and when it should apply. Workbook rules travel with a workbook, personalization applies to your account across workbooks, and skills package a repeatable task.
As an Amazon Associate I earn from qualifying purchases.
| Approach | Best for | Sharing and scope | Setup |
|---|---|---|---|
| Workbook rules | Conventions specific to a file, such as how its columns should be formatted or interpreted | Rules stay with the workbook; people working from the shared file get those rules too | A visible worksheet named .Rules, with rules in column A |
| Personalization | Your recurring preferences, such as date format, formula style, or how explanations should be written | Follows your account across workbooks and Copilot sessions; it is not a workbook-sharing mechanism | Copilot pane > Settings > Personalization |
| Skills | A procedure you want Copilot to use for a task you perform repeatedly | Reusable task instructions; they are separate from workbook-specific rules and account preferences | Select a skill from Add work content, invoke it with @name, or create a custom skill folder containing SKILL.md |
These options are complementary. For example, workbook rules can define how a particular sales file labels its regions, personalization can specify your preferred currency format, and a skill can describe a recurring monthly summary task.
Set up rules that travel with one workbook
Microsoft’s guidance places workbook rules on a worksheet titled .Rules. The worksheet must be visible, and the rules must be listed in column A. You can ask Copilot to create the rules sheet from the Copilot pane’s Add work content menu, or add the worksheet yourself. Because the rules are stored in the workbook, they travel when you share that file.
#1 Best Overall
- The Microsoft Office 365 Bible: The Most Updated and Complete Guide to Excel, Word, PowerPoint, Outlook, OneNote, OneDrive, Teams, Access, and Publisher from Beginners to Advanced
- ABIS BOOK
Write rules Copilot can apply
- Put one rule or idea in each cell, and use headings to group related rules.
- Keep each instruction short and specific. Name the relevant worksheet, columns, or data when that helps make the rule unambiguous.
- Include a brief example of the output you want. Microsoft’s guidance says, “Showing the desired result is more effective than describing it.”
- Keep the rules focused on the workbook rather than mixing in general preferences that belong in Personalization.
Rules can also use formulas so the guidance adapts to workbook state—for example, changing according to a dropdown selection or whether data is present. Microsoft notes that rule behavior may evolve as Copilot and its available models change. Rules are fully supported only in English; support in other languages is inconsistent. See Microsoft’s instructions for Copilot in Excel rules.
Save preferences that should follow your account
For a preference you want across your own workbooks, open the Copilot pane, choose Settings, then Personalization. Microsoft gives examples such as number and currency formats, date and unit conventions, formula preferences, chart defaults, and the style of explanations you prefer.
Use several short, specific preferences rather than one long paragraph. They take effect on your next prompt, and an instruction in a particular prompt can override a saved preference. That makes Personalization useful for your defaults, while a workbook’s .Rules sheet is the better place for conventions every collaborator needs to follow. See Microsoft’s Personalization guidance.
Quick wins for a faster PC:
Clear out junk files and repair common Windows errorsFree Scan →Scan for outdated or missing drivers - takes under a minuteDriver Scan →Use a skill for a task you repeat
A skill gives Copilot instructions for a reusable procedure. To use one, choose it from the Copilot pane’s Add work content menu or call it directly with its name, such as @name. In Skills settings, you can enable or disable automatic use. Turning off automatic use does not prevent you from calling a skill explicitly.
Create a custom skill
- Open Manage skills and choose Custom skills.
- Create or open the OneDrive skills folder, then add a folder for the skill.
- Put a
SKILL.mdfile in that folder. Its required frontmatter names the skill and describes when Copilot should use it; the rest of the file contains the task instructions. - Refresh the custom skills area after adding or renaming a folder.
Optional scripts, reference files, and assets can support a skill and help it produce more predictable results. Microsoft’s guidance names managed skills such as @brandkit and @theme-design; its built-in skills page also describes chart-design. For current skill setup and management steps, see Microsoft’s guide to skills in Copilot for Excel.
Build prompts around the actual workbook task
Saved instructions establish defaults; your prompt still needs to say what you want done with the data in front of Copilot. A useful prompt names the output, identifies the relevant columns or range, and states any calculation or formatting convention that matters.
Rank #4
- Say what to create or change, such as a summary table, a formula, or a chart.
- Identify the worksheet, table, columns, or range the task should use.
- State task-specific requirements that are not already covered by your rules, preferences, or skill.
- Review the response or proposed changes. If it misses the mark, refine the request or ask a follow-up question.
Structured data is a helpful starting point: use a table or range with one header row, one type of item per column, and avoid scattered merged cells. If the result is not what you intended, make the missing detail explicit rather than relying on a broad saved instruction to resolve it. Microsoft’s Copilot in Excel getting-started guidance also recommends specific prompts and refining them as needed.
Review Copilot’s changes before relying on them
Copilot can generate incorrect results or misinterpret information. Check formulas, data, and formatting in the workbook before using the output. Do not treat Copilot’s response as the sole basis for sensitive financial, legal, or medical decisions. Microsoft also cautions that feature availability and the experience can vary with subscription, organizational settings, platform, and rollout.
Copilot in Excel may offer edit, plan, and chat modes, but not every user will see the same modes. Edit mode can make direct workbook changes; plan mode lets you review a proposed approach first; chat mode keeps the response in the conversation. When a mode is available, choose it based on how much control you want before changes are applied. Consult Microsoft’s Copilot in Excel FAQ for limitations and its Excel tutorial for screen reader users for structured-data and workflow context.
Quick Recap
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
