What are workbook rules in Copilot for Excel?

Workbook rules are instructions saved inside an Excel file on a worksheet named .Rules. They tell Copilot how to handle that specific workbook, including formatting conventions, custom functions, and layout needs. Because the rules live in the file, Copilot follows them for anyone who uses it on the shared workbook, with no separate setup.

How is Copilot personalization different from workbook rules?

Personalization belongs to you. It's saved to your Microsoft account and applies in every workbook where you use Copilot in Excel, on any device signed in to that account. Workbook rules belong to the file. They travel with the workbook when you share it, so Copilot applies the same standards for everyone using it there.

Do I need a paid Copilot license to use these features?

It depends on your plan. Microsoft lists three Copilot access levels for work accounts, and the basic Copilot Chat level doesn't include Copilot inside Excel. The full experience comes with the paid Microsoft 365 Copilot add-on, which sits on top of a qualifying Microsoft 365 plan. Check each person's access level before you plan around it.

Will workbook rules make my coworkers format things the same way?

No. Rules guide Copilot, not people. When anyone asks Copilot to edit the workbook, it follows the .Rules sheet. A coworker typing or pasting by hand can still do things their own way. Rules work best on shared templates and recurring reports where people already lean on Copilot for the formatting.

Is it safe to use Copilot on financial spreadsheets?

Use it, but check it. Copilot can apply your formatting perfectly and still grab the wrong range or build a formula that looks right and isn't. Review totals and spot-check formulas on anything tied to payroll, taxes, invoices, or reports to a bank or board. Treat its work like a capable new hire's first draft.

How can Cyber Shift Technologies help my Northeast Ohio office use Copilot in Excel?

Our North Canton team supports businesses across Canton, Akron, and Stark County. We can check which Copilot access each person on your team has, turn on the Microsoft 365 features you already pay for, and help you build personalization settings and a .Rules sheet around a report your team rebuilds every week.

Copilot in Excel Rules: North Canton OH Guide

The Slow Part of Excel Is the Cleanup

Most people who live in Excel don’t struggle with the math. The formulas work. The slow part is everything that happens after the numbers land.

Picture the office manager at a Canton distributor who pulls weekly sales every Monday morning. The export from the accounting system comes out rough. So she fixes the dates, adds dollar signs, rounds to two decimals, bolds the headers, and moves the region totals to where the owner expects them. It’s half an hour of work she’s done more times than she can count.

Then she takes a week off. A coworker covers, and the report comes out looking different.

Negative numbers show up in red instead of parentheses. The totals move to the bottom. The owner calls to ask which version is right.

That’s the real cost.

It isn’t only the time on one report. It’s the drift between people who all do the same job a little differently, and the questions that drift creates.

Copilot in Excel could already help with pieces of this. You could ask it to format a column or build a chart. However, you had to ask every time, in every file, and it had no idea how you liked it done last week. Two newer features address exactly that.

Personalization: Your Preferences, Saved to Your Account

Personalization is the one for you as an individual. You tell Copilot how you like things done, once, and it applies those preferences whenever you use it in Excel.

Microsoft’s own examples center on number formatting: how currency symbols display, how many decimal places you want, whether you use thousands separators, and how negative numbers and percentages should look (Microsoft Support, “Personalize Copilot in Excel”). So if your firm always shows negatives in parentheses and money to two decimals, this is where that goes.

Setup takes a minute. In the Copilot pane, open the settings menu (the three dots in the upper-right corner), choose Personalization, type your preferences, and save.

Because it’s saved to your Microsoft account, it follows you. Open Copilot in Excel on your office desktop in North Canton or your laptop at home, and the same preferences apply on any device signed in to that account. Microsoft announced personalization as generally available on Excel for the web, Windows, and Mac in June 2026 (Microsoft Excel Blog, “New ways to customize how Copilot edits your workbooks”).

One limit matters here. Personalization doesn’t travel with the file. It’s yours. When a coworker opens the same workbook, Copilot works from their settings, not yours.

Where to Start

Begin with the formatting you fix most often. For most offices, that’s currency, decimal places, and how negative numbers display. Keep each preference short and specific, one idea at a time.

Workbook Rules: A House Style That Travels With the File

Workbook rules solve the team problem. Instead of living in your account, the rules live inside the workbook itself, on a worksheet named .Rules. When you share the file, the rules go with it, and the person you share it with doesn’t have to set anything up (Microsoft Support, “Create guidelines for a workbook with Copilot in Excel rules”).

That matters for the files a whole office touches. Think of a job-costing template at a Stark County machine shop, the monthly production report at an Akron dental practice, or the grant budget a nonprofit’s bookkeeper and board treasurer both edit. Each one has a right way to look. Usually that knowledge lives in one person’s head.

With rules, it lives in the file. According to Microsoft, rules can set formatting conventions, custom functions, and layout needs for that one workbook. Copilot then follows them for edits made in the workbook, no matter who is asking.

A few mechanics from Microsoft’s support article are easy to miss:

The sheet must be named .Rules, period included.
Rules go in column A, one rule per cell.
The sheet has to stay visible. Copilot ignores a hidden .Rules sheet.
Rules are only fully supported in English.

You can start one from the Copilot pane, which builds a .Rules sheet with a suggested template. You can also create the sheet yourself, or copy one from another workbook. Microsoft says short, specific rules work best.

As for timing, Microsoft’s August 2026 Excel update listed workbook rules as rolling out to general availability on Excel for the web, Windows, and Mac. Rolling out means some accounts may not see it yet.

Rules Guide Copilot, Not People

A .Rules sheet tells Copilot how to handle the file. It doesn’t stop a coworker from typing over a header or pasting raw numbers by hand. Also, anyone you share the file with can read the rules sheet. Write it like a style guide, and keep passwords, client details, and internal notes off it.

Who Can Use This: Check Your License First

Here’s where a lot of offices get tripped up. A Copilot button in Excel doesn’t mean you have the full Copilot in Excel experience.

Microsoft’s support page on Copilot licensing lists three levels of access for work accounts, and they don’t all include Copilot inside Excel. The lowest level, labeled Copilot Chat (Basic), doesn’t include access to Copilot in Word, Excel, PowerPoint, and OneNote. The full experience comes with the paid Microsoft 365 Copilot add-on, which sits on top of a qualifying Microsoft 365 plan (Microsoft Support, “What Copilot license do I have”; Microsoft Learn, “License options for Microsoft 365 Copilot”).

Also, the file has to be editable. Copilot won’t work in a read-only workbook, which trips people up with files opened from email attachments.

Microsoft adjusts Copilot plans and names often. So before you promise your team anything, find out which access level each person has. Microsoft’s support article explains how to check one account at a time. Your IT provider can also pull license assignments for the whole company from the Microsoft 365 admin center.

Status as of September 24, 2026

Personalization: generally available on Excel for the web, Windows, and Mac (Microsoft, June 2026).
Workbook rules: rolling out to general availability on the same platforms (Microsoft, August 2026).
Full Copilot in Excel access: depends on each person’s Copilot license.

Keep a Person on the Numbers

None of this replaces a careful set of eyes. Copilot can format a report exactly the way you like and still pull the wrong range, misread a column, or build a formula that looks right and isn’t. In fact, clean formatting can make a wrong number look more trustworthy.

So treat Copilot’s spreadsheet work the way you’d treat a capable new hire’s first draft. Check the totals. Spot-check the formulas. Be extra careful with anything tied to payroll, taxes, invoices, or what you report to a bank or a board.

The smart path for a small office is to start small. Pick one report that gets rebuilt every week, write five or six rules for it, and see whether it saves time without creating new cleanup.

Before You Roll This Out to Your Team

Confirm each person’s Copilot access level before you plan around these features.
Set your own personalization first: currency, decimal places, negative numbers.
Pick one shared workbook that gets rebuilt often and add a .Rules sheet to it.
Keep the .Rules sheet visible, in English, with one short rule per cell in column A.
Keep sensitive details off the rules sheet, because anyone with the file can read it.
Check every Copilot-built total and formula before the report leaves the building.

Cyber Shift Technologies has worked with 235+ businesses since 2016. Our team helps offices in North Canton, Canton, Akron, and the rest of Northeast Ohio figure out which Microsoft 365 licenses they actually have, turn on the features they’re already paying for, and set them up so they help instead of adding confusion. And support and SOC monitoring are available 24/7/365.

Find Out What Your Microsoft 365 Licenses Actually Include

If someone in your office fixes the same Excel report every week, let’s see whether Copilot can take that off their plate. Our North Canton team will check which Copilot access your people have and show you how to set up personalization and workbook rules on one real report.

Call: 330-353-8420
Email: info@cybershift.com
Web: cybershifttech.com/contact

No pressure. Just a straight conversation about where you stand and what, if anything, needs to change.

Copilot in Excel Rules: How to Teach Copilot Your Formatting Once