Call our Glasgow IT support team: 0141 255 1617

IT Strategy & Planning

You can now teach Copilot how you want Excel to work

Microsoft is making Copilot in Excel more useful by letting it remember your preferences and follow rules built into individual spreadsheets.

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.

Frequently asked questions

Can Copilot in Excel remember my preferences?

Yes. Copilot can use saved personal preferences such as formatting, layout and reporting choices when helping you in Excel. Those preferences are linked to your own Copilot experience rather than being automatically applied to everyone who opens the same spreadsheet.

What are workbook rules in Excel?

Workbook rules are instructions associated with a particular spreadsheet. They can tell Copilot how that workbook should be formatted or handled, which can help maintain consistency when several people work with the same file.

Do Excel workbook rules stay with the file?

Yes. Workbook-specific rules remain with the spreadsheet, so the instructions can still be available when the file is shared with colleagues.

Is Copilot safe to use with financial spreadsheets?

Copilot can save time, but its output should still be checked. This is particularly important when spreadsheets contain financial figures, forecasts, formulas or information used to make business decisions.

Can Acu IT Solutions help with Microsoft 365 and Copilot?

Yes. Acu IT Solutions helps businesses make better use of Microsoft 365, including identifying where Copilot and other productivity tools can save time while maintaining sensible security and oversight.

Could Microsoft 365 help your team work more efficiently?

Acu IT Solutions helps businesses get more from Microsoft 365, from everyday productivity improvements to understanding where tools such as Copilot could genuinely save time.

Talk to Our IT Experts

Microsoft 365 and Copilot features can vary according to licence, platform and organisational settings. AI-generated spreadsheet content should always be reviewed where accuracy is important.