Microsoft is giving Excel users a long-awaited quality-of-life upgrade: Copilot will now remember how you like your data presented. In a June 2026 update rolling out to Microsoft 365 subscribers, Copilot in Excel introduces persistent personalization settings that let you define default formats, formulas, table styles, chart types, PivotTable configurations, and explanation preferences across all your workbooks. The feature addresses a common frustration among spreadsheet professionals—repeatedly telling the AI assistant to apply the same formatting or calculation logic to different datasets.

The new Copilot personalization panel, accessible from the ribbon or the Copilot sidebar, stores a user’s standing preferences. Once set, any Copilot-generated output—whether a simple SUMIF formula or a complex PivotTable analysis—automatically conforms to the user’s chosen defaults. This eliminates the tedious back-and-forth of tweaking outputs and brings Copilot closer to a true personal productivity partner.

How the Personalization Engine Works

The personalization system is built around a set of declarative preferences that Copilot references before generating any response. Users can specify:

  • Number and date formats: Choose a default number format (currency, accounting, percentage, scientific) with custom decimal places, thousands separators, and regional date structures. For example, a European user can set the default to use dd/mm/yyyy dates and € currency, while a U.S. analyst can stick with mm/dd/yyyy and $. Copilot applies these formats to all generated data tables and formula outputs.
  • Formula preferences: Define a preferred function style. Users can instruct Copilot to always use XLOOKUP instead of VLOOKUP, prefer LET and LAMBDA for advanced calculations, or fall back to classic SUM/AVERAGE for readability. The engine also lets you set a default error-handling approach (e.g., wrap all formulas in IFERROR or return N/A).
  • Table and range styles: Select a standard table style (from the built-in gallery or a custom theme) and choose whether generated tables should have header rows, banded columns, total rows, or filter buttons. Copilot also follows your preference for named ranges—automatically applying semantic names like “Sales_Data” instead of generic “Table1”.
  • Charting defaults: Pick a preferred chart type (clustered bar, line, scatter, etc.), color palette, title placement, and legend position. Copilot generates charts that match your corporate branding or personal taste without requiring post-creation reformatting.
  • PivotTable configurations: Set a default layout (tabular, compact, or outline), decide whether to include grand totals and subtotals, and specify a standard number format. Copilot then structures any PivotTable it creates using these rules.
  • Explanation verbosity and tone: Choose how Copilot explains its work—concise one-line summaries, step-by-step breakdowns, or full narrative descriptions. You can also set the tone (professional, casual, teaching) to match audience expectations.

These preferences are saved at the account level and roam with your Microsoft 365 profile. They apply to both new and existing workbooks unless overridden in a specific document’s personalization settings. IT administrators can also push organization-wide defaults through Group Policy or the Microsoft 365 admin center, ensuring consistency across teams without stifling individual tweaks.

A New Level of AI Efficiency in Excel

Before this update, Copilot in Excel operated statelessly for each query. A user asking for a sales trend chart would get whatever Copilot deemed best—often a default blue column chart—forcing them to waste clicks reformatting or re-requesting with explicit instructions. The new personalization layer shifts the paradigm: you teach Copilot once, and it faithfully reproduces your style forever.

Power users who build daily reports will see the biggest productivity gains. Imagine a financial analyst who always needs currency-formatted PivotTables with compact layout and a specific color palette. Previously, each Copilot interaction required saying “create a PivotTable with these exact settings.” Now, after configuring preferences once, a simple “Analyze Q3 sales by region” yields a ready-to-present PivotTable. The time savings compound across hundreds of weekly interactions.

Educators and trainers also benefit. A professor who prefers Copilot to explain formulas in a teaching tone with step-by-step logic can ensure students receive consistent, pedagogical responses. Similarly, business users who share Copilot-generated analyses with non-technical stakeholders can set the explanation style to “concise” to avoid overwhelming details.

Community Reaction and Early Feedback

While the update is just rolling out, early reaction on Windows forums like Windows Forum has been enthusiastic. One power user noted, “This is the missing piece—I can finally stop fighting Copilot’s style choices and just focus on the analysis.” Another raised a valid point: the ability to share preference profiles across a team could accelerate onboarding and maintain report consistency.

Some users worry about flexibility. If every output strictly follows defaults, does that limit Copilot’s ability to choose the best visualization for the data? Microsoft addresses this with an optional “Suggest improvements” toggle that lets Copilot override preferences when it calculates a significantly better chart type or formula structure, while still alerting the user and offering a one-click revert.

Enterprise administrators are keeping a close eye on the governance controls. The initial rollout allows centralized management of all preference categories, which is crucial for regulated industries. However, a few admins on Windows Forum expressed hope for even finer-grained controls—like locking certain categories while leaving others up to users.

Under the Hood: Technical Implementation

Microsoft has not publicly detailed every aspect, but a peek at the supporting documentation reveals that preferences are stored in a lightweight JSON schema within the user’s Microsoft account. The schema includes a version field for forward compatibility and a context field that preserves the last-used workbook-level overrides. When Copilot generates content, a low-latency call first fetches the user’s preferences and merges them with the current workbook’s settings before invoking the large language model.

The system uses a prompt-engineering layer that injects a “persona” block into every Copilot request. For instance, if a user’s chart default is set to “clustered bar, Office 2022 palette,” the hidden prompt snippet reads: “
When creating a chart, use a clustered bar type with the Office 2022 color palette. Title alignment should be centered, legend at bottom. Do not deviate unless the data unequivocally demands a different type." This ensures the AI model honors preferences without additional tokens from the user.

This approach also means the personalization works across all AI endpoints—whether Copilot is generating a formula, constructing a PivotTable, or summarizing a data range. The same preferences govern every output type, maintaining consistency.

What’s Next for Copilot Personalization?

This June 2026 release lays the groundwork for deeper personalization. Industry insiders expect future updates to include:

  • Conditional formatting preferences: Define rules for how highlights, data bars, and color scales appear by default.
  • Macro-aware preferences: Allow Copilot to generate VBA macros that respect personal coding styles (e.g., Option Explicit always on, specific variable naming conventions).
  • Project-level profiles: Save sets of preferences tailored to specific clients, projects, or report types, enabling quick switching.
  • AI-driven preference discovery: Copilot could analyze a user’s manual formatting history to suggest optimal default settings.

Microsoft’s broader vision is to make Copilot an ambient expert that doesn’t just respond to queries but proactively shapes the user’s work environment. Personalization in Excel is a critical step, and it likely foreshadows similar updates across Word, PowerPoint, and Outlook.

Practical Setup Guide

To activate and configure Copilot personalization in Excel:

  1. Open Excel and select the Copilot button on the Home ribbon (or press Alt+Shift+C).
  2. In the Copilot sidebar, click the gear icon (⚙️) to open Copilot Settings.
  3. Choose Personalization from the left navigation.
  4. Browse through the categories: Formats, Formulas, Tables, Charts, PivotTables, and Explanations.
  5. In each category, select your preferred defaults. For formats, you can test the look in a live preview cell.
  6. Toggle the Suggest improvements option on or off—leaving it on lets Copilot break defaults if it deems it beneficial (with notice).
  7. Click Save. The settings immediately apply to all subsequent Copilot interactions across your installed Excel instances.

Users with multiple Microsoft 365 accounts can manage separate preferences per account, and roaming ensures a consistent experience on the web, Windows, and Mac.

The Competitive Landscape

Google Sheets has long offered some macro-based automation and template saving, but nothing on par with an AI assistant that learns user style. Apple’s Numbers lacks any AI personalization. This move gives Excel a clear edge for data professionals who rely on speed and consistency. It also strengthens the Microsoft 365 ecosystem lock-in—once you’ve perfected your Copilot preferences, switching to another spreadsheet tool means rebuilding that efficiency from scratch.

Third-party Excel add-ins that injected AI assistance have struggled to gain traction partly because they couldn’t integrate deeply with native formatting and formula engines. Copilot’s personalization, built right into the Office backend, is a definitive response to that gap.

Potential Drawbacks and Mitigations

No update is perfect, and some early adopters have reported minor glitches. A few users noticed that preferences didn’t immediately sync after changing accounts, though a quick sign-out resolved it. Others wish for a “preference reset” button that can revert to factory defaults in one click—Microsoft says that’s coming in a post-release patch.

Privacy-conscious users might ask: are my formatting preferences used to train AI? Microsoft’s documentation states that personalization data is only used to tailor Copilot outputs for each user and is not shared with the public model training pipeline. IT admins can verify this in the Microsoft Purview compliance portal.

Final Thoughts: A Smarter Excel for Everyone

Copilot personalization transforms the assistant from a generic helper into a bespoke analyst. It acknowledges that spreadsheet work is deeply personal—from the way numbers are displayed to how insights are communicated. By eliminating repetitive formatting and style instructions, Microsoft unlocks a new tier of productivity that lets users focus on what the data means, not how it looks.

For everyday users, it means less frustration and faster results. For power users, it’s a force multiplier that shaves hours off weekly reporting cycles. And for the enterprise, it promises a new standard of output consistency without sacrificing individual creativity. The June 2026 update might not make headlines like a new AI model, but for the millions who live in Excel, it’s the kind of thoughtful improvement that defines best-in-class software.