Copilot in Excel Can Now Learn Your Rules (So You Can Stop Repeating Them)
If you use Excel a lot, you already know the secret. Finding the answer is not the hard part.
The hard part is getting that answer to look the way you want.
Maybe you always show money with two decimal places. Maybe your reports need the same headings every single time. Maybe your team has a "right way" to name tabs, build formulas, and lay out a sheet, and everyone is expected to follow it.
It's the same fixes, over and over. Bold this. Move that. No, the other date format.
And repetitive work is exactly what AI is supposed to take off your plate.
What's New With Copilot in Excel
Microsoft has been building Copilot into Excel for a couple of years now. Some updates have been great. Some have been "huh, neat" and then forgotten by lunch.
This one could actually change your day.
Copilot in Excel can now learn how you like things done.
You can tell it things like:
How you want currency to show up
How your reports should be laid out
How certain kinds of data should be formatted
Once you explain your preferences, Copilot remembers them. Next time, it applies them on its own. No more re-teaching it every Monday morning.
If you've ever made the same five tweaks to every spreadsheet you touch, this is very good news. Your mouse-clicking finger can finally take a vacation.
Workbook Rules: Fewer "Final_v2" Files
There's a second part of this update that's even better for teams.
Lots of businesses run on shared spreadsheets. Everyone is supposed to follow the same rules. In real life, it goes like this:
One person builds the report one way.
Someone else builds it a little differently.
A third person "fixes" both of them.
Now you've got three versions of what should be one document. Each one has a different number at the bottom. And somebody has to sit in a meeting and figure out which one is real.
Microsoft's answer is workbook rules. These are instructions you save directly in the spreadsheet. They tell Copilot how to handle that specific file.
The best part? The rules travel with the file. When you share the workbook with a coworker, the rules go along for the ride.
That means more consistency across your team, without one poor soul having to explain the same formatting rules for the 50th time.
Why Copilot in Excel Is Moving Beyond Answering Questions
Up until now, most people used tools like Copilot to write content, summarize information, or explain a confusing formula.
That's helpful. But this update feels different. It's less like asking a question and more like teaching the software how your business works.
When the AI knows your preferences and your processes, its results get more useful. It stops giving you a generic answer and starts giving you your answer, in your format.
Don't Skip the Human Check
Here's the important part. This does not mean you can stop paying attention.
Spreadsheets often hold important business information. Anything AI creates should still be checked before you rely on it. That goes double for:
Formulas
Financial figures
Reports going to your boss, your board, or your bank
Copilot can remember your rules. It can still get things wrong. Think of it like a smart new hire. Helpful, fast, and still needs someone to look over its work.
A Small Change That Saves Real Time
For the boring, everyday tasks that quietly eat your week, Copilot in Excel learning your rules is a smart step forward.
If Excel spends less time asking how you want something formatted, and more time helping you get work done, that's a trade worth making.
Want help? We can show you which AI tools inside Microsoft 365 could save your team time, and help you set them up safely. Get in touch with us today.
Comments