Quick Answer:
Microsoft’s Copilot in Excel can now remember how you like your spreadsheets set up, so you don’t have to keep explaining it. A spreadsheet can also carry its own set of rules, and those go with the file when you share it with someone else. The result should be less time typing instructions and more consistency across your business spreadsheets.
Be honest: how many times have you opened Excel and made exactly the same changes you made last time?
Maybe you always show money a certain way. Maybe your monthly report needs the same headings every time. Maybe your team has its own way of laying things out, and everyone is expected to stick to it.
None of it is hard. It’s just boring, and it eats into your day.
Copilot can now remember how you like things done
Copilot is the AI assistant built into Microsoft 365. You type what you want in plain English and it helps with the spreadsheet. Some of its Excel features have been more useful than others.
This one looks genuinely practical. You can now tell Copilot your usual preferences and it will keep them in mind.
For example, you could tell it:
- to show money in pounds, not dollars
- to write dates the UK way
- how you like your tables laid out
- whether totals go at the top or the bottom
- how much explanation you want with its answers
- which kinds of chart you prefer
- how you like your formulas written
Once those preferences are saved, Copilot can use them whenever you ask it for something in Excel.
No more repeatedly typing “use pounds, UK dates, totals at the top” every time you ask for a report.
Your preferences stay with you
There’s a difference between the two parts of this update, and it’s worth knowing.
Your personal preferences are tied to your own Copilot account. They aren’t saved inside the spreadsheet, and they don’t get forced on anyone else who opens the same file.
Think of it like the seat and mirror settings in your car. They suit you, and they follow you from one spreadsheet to the next.
If you produce financial reports regularly, that might cover your usual currency format, the chart styles you like, and how much explanation you want alongside the numbers.
A spreadsheet can carry its own rules
The second part is probably the more useful one for businesses.
You can now add rules to a specific Excel file. They tell Copilot how that spreadsheet should be handled.
The rules are kept on their own worksheet inside the file. So when you share the spreadsheet with a colleague, the rules go with it.
That matters because the person opening the file doesn’t need to know all the habits behind it. The “we always do it this way” knowledge is written down in the file itself, where Copilot can read it.
Why this matters for your business
Think about the spreadsheets your business uses every month:
- management reports
- sales trackers
- budgets and forecasts
- project plans
- stock and purchasing records
- monthly performance reports
Most of these have a proper way of being done.
One person knows it because they built the spreadsheet. Another copies last month’s version. A third changes the formatting because they like it better that way.
Before long, what should be one report turns into three, each looking and behaving a bit differently.
Workbook rules are one way to stop that happening. You could tell Copilot that certain columns must always use a particular format, that management reports need a set structure, or that charts should follow an agreed layout.
It’s a small change. But it means Copilot isn’t only answering one-off questions any more. It’s starting to understand how your team actually works.
Less explaining, more getting on with it
When AI tools first took off, most of the attention was on asking questions and getting text written.
That’s handy, but nobody wants to explain how their job works to a tool every single time they open it.
If Copilot already knows your preferences and your team’s habits, using it gets a lot more practical. Instead of typing this:
“Create this report, but use our normal currency format, structure the summary like last time, keep the formulas simple and put the totals at the top.”
You can just say what you actually want done.
Still check its work
Don’t hand Copilot the keys to your important spreadsheets and walk away.
It can get things wrong. It can misread what you asked for, or change something it shouldn’t have.
That matters most when a spreadsheet holds financial figures, forecasts, formulas, or numbers your business uses to make decisions.
Use Copilot to cut down the repetitive jobs. Keep a person in the loop to check the result.
Small time savings add up
This isn’t an update that will change how your business runs overnight.
But the small ones are often the ones people notice. A few minutes saved on formatting here, a bit less tidying-up of someone else’s spreadsheet there, and it soon adds up over a month.
It also shows where Microsoft is heading with Copilot. The idea is less about a chatbot sitting in a side panel and more about a tool that learns how you work and takes care of the repetitive bits.
If your business already uses Microsoft 365, that’s when Copilot starts to look considerably more useful.