Microsoft Copilot in Excel Subscription Requirements and Operating Modes
Microsoft’s AI Copilot in Excel requires a separate subscription in addition to a Microsoft 365 or Excel license, according to reporting by intheblack. The subscription bundle covers Copilot across Word, PowerPoint, Outlook, and Excel. When active, the Copilot icon appears in the bottom-right corner of the Excel interface, where users can right-click to dock or move it to the ribbon.
Copilot in Excel currently has three modes. In Allow Editing mode, the tool builds fully formatted spreadsheets from scratch or modifies existing files based on user prompts. The Plan mode drafts a design solution for user review before execution, while Chat Only functions as a standard question-and-answer prompt interface.
Customizing Instructions and Managing Rules Sheets
Copilot includes a personalization section accessible through the Chat Only mode by clicking the ellipsis next to the close button of the task pane and selecting Settings. Turning on Custom Instructions allows professionals to specify persistent rules for Excel that apply across tasks.
A recent update introduces a dedicated sheet named .Rules, which holds operational rules in column A that Copilot follows when building workbook solutions. According to intheblack, text-based formulas are allowed in column A, enabling dynamic rules tied to input cells or other file data. This setup reduces the number of instructions required in individual prompts and allows organizations to enforce consistent formatting guidelines.
Technical Limitations and Model Selection Options
Furthermore, Microsoft Support notes that users can choose between different generative AI models before submitting a prompt by using the model picker in the upper-left corner of the Copilot pane, which supports the latest Anthropic and OpenAI models.
Commercial subscribers require administrator approval in the Microsoft 365 Admin Center to access Anthropic AI models. Model selections apply exclusively to the active session; closing Excel reverts Copilot to the default Microsoft 365 generative AI model. Users can also manage autosave features to experiment with changes without automatically saving workbook modifications.
Testing and Reviewing AI-Generated Spreadsheet Outputs
Best practices include instructing Copilot to use helper cells to split complex calculations across multiple ranges and requesting centralized validation sheets to verify individual formulas. Additionally, users can access previous chat histories via the menu icon in the upper-left corner of the Copilot pane or review workbook change history to track edits.
Frequently Asked Questions About Copilot in Excel
Does Excel Copilot come included with a standard Microsoft 365 subscription?
No, intheblack reports that Copilot requires a separate paid subscription in addition to your Excel or Microsoft 365 license, though that single subscription also covers Word, PowerPoint, and Outlook.
How do you switch between different AI models in the Excel Copilot pane?
Microsoft Support notes that users can select their preferred model using the model picker menu in the upper-left corner of the Copilot in Excel pane before submitting a prompt.
What is the purpose of the .Rules sheet in Copilot?
The .Rules sheet holds specific rules in column A that Copilot follows when building solutions, reducing the need for repetitive instructions in individual prompts, as detailed by intheblack.