Excel Copilot Finally Gets Custom Rules to End Repetitive Formatting Prompts

Repetitive formatting prompts in spreadsheets are a massive time sink, but Microsoft has introduced custom rules for Copilot in Excel to finally solve this problem. The AI assistant now features persistent memory capabilities, allowing users to define fixed formatting rules and styles directly within their workbooks.

This update acts much like ChatGPT's persistent memory, eliminating the need to constantly tell the AI how to format your data. Instead of repeatedly asking the assistant to adjust borders or text formats, users can now establish baseline behaviors that the AI will remember across sessions.

To stop repeating yourself and automate your workflow, you can configure individual preferences using simple natural language.

• Navigate to the Settings menu and open the Personalization section.
• Enter your specific formatting preferences using natural language (for example: "Always format currency in USD with no decimal places").
• Copilot will automatically apply these guidelines to all future actions, ensuring your data remains consistent without additional prompting.

For team collaboration, Microsoft is expanding this functionality to the enterprise level through workbook-specific rules. These settings are automatically saved in a hidden sheet named:

.Rules

When you share the document with other team members, the established design standards, dynamic formulas, and naming conventions remain intact. This ensures the AI edits consistently regardless of who opens the file. Furthermore, Copilot can analyze an already structured sheet to infer and generate new rule sets based on existing practical examples.

Individual personalization options are currently live for all Copilot users in Excel across the Web, Mac, and Windows platforms. Meanwhile, the structured workbook rules are in the testing phase for Windows and Mac Insiders, with a global rollout expected in the coming weeks.

This update fundamentally shifts Copilot from a reactive assistant to a proactive workflow engine. By embedding the rules directly into the workbook architecture, Microsoft is solving the biggest friction point in enterprise AI adoption: consistency.

Teams no longer have to worry about a colleague's poorly phrased prompt breaking a standardized financial model. The hidden sheet approach is a brilliant technical workaround that ensures AI compliance without requiring complex backend governance, making enterprise-grade automation accessible to everyday users.