Skip links
Illustration of AI-powered data formatting and analysis with Copilot in Excel

Copilot in Excel Update: How AI Now Learns Your Formatting Rules

Microsoft’s Copilot in Excel can now learn a business’s formatting preferences. It applies those preferences automatically going forward. Users can teach Copilot how they want currency displayed. They can also set how reports should be structured, or how specific data types should look. Once someone sets those preferences, Copilot remembers them for future tasks. This removes the need to repeat the same instructions every time a spreadsheet comes up.

For professional services firms in Kelowna and across the Okanagan, this solves a familiar frustration. Anyone who works in Excel daily knows that entering data isn’t the hard part. Formatting it consistently is.

What Is Changing With Copilot in Excel?

Microsoft has expanded Copilot’s capabilities inside Excel over the past two years, with mixed results. This latest update targets a genuinely common pain point: repetitive formatting requests. Previously, Copilot in Excel treated every request as a fresh instruction. Now, it retains formatting preferences across sessions.

For example, a firm might always display figures in CAD with two decimal places. Or they might structure monthly reports with the same headings every time. They can set that expectation once. Copilot then applies those rules automatically in future spreadsheets, without anyone asking again.

How Do Workbook Rules Improve Team Consistency?

The second piece of this update tackles a different problem: shared spreadsheets that drift out of consistency over time. In many offices, one team member builds a report one way. A colleague adjusts it differently. Within a few reporting cycles, three versions of what should be a single standardized document start floating around.

Microsoft’s new workbook rules solve this. The rules attach formatting instructions directly to the spreadsheet file itself. When someone shares a workbook, its rules travel with it. As a result, anyone who opens that file works from the same formatting standards. This holds true regardless of who created the original document.

This matters most for firms that rely on shared financial models, client reporting templates, or compliance documentation. Consistency isn’t just a convenience there. It’s often a professional requirement.

SkySail Technologies regularly sees version-control issues arise from this kind of informal, person-to-person formatting drift when working with Okanagan accounting and professional services firms. Workbook rules give firms a way to enforce a standard. They no longer need manual training or repeated reminders to do it.

What Should Businesses Consider Before Relying on AI-Formatted Spreadsheets?

This update shifts what Copilot does. Earlier versions focused on generating content, summarizing data, or explaining formulas on request. This update asks Copilot to learn how a specific business operates. It then applies that understanding automatically. In principle, this should make results more useful over time. The AI works from an accumulated understanding of a firm’s preferences, rather than starting from scratch each time.

That said, human oversight still matters. Spreadsheets often contain sensitive financial data, client information, or figures used in regulatory reporting. Someone should still review any AI-generated formatting or calculation before relying on it. This holds especially true where formulas, financial totals, or client-facing reports are involved. SkySail recommends treating Copilot’s output as a strong first draft, not a final answer. This matters especially for firms subject to compliance requirements such as those under PIPEDA.

Why This Matters for Kelowna and Okanagan Businesses

For small and mid-sized professional services firms — accounting practices, law offices, and consultancies across the Interior BC region — time spent on repetitive spreadsheet formatting is time not spent on client work. This update reduces that friction. It also keeps formatting consistent across a team. That addresses a real operational cost, not just a cosmetic feature.

If Excel spends less time asking how something should be formatted, it can spend more time helping teams produce accurate, consistent reporting. That’s a meaningful step forward for day-to-day productivity, not just a novelty update.

Want to understand which Microsoft 365 Copilot features could genuinely improve productivity for your Kelowna or Okanagan team? Our IT support specialists can walk through your current setup and identify practical next steps.