Microsoft has introduced a new way to interact with its AI assistant in Excel, transforming Copilot into a fully functional formula that works just like traditional Excel functions. Previously, Copilot in Excel was accessible through buttons or sidebars, helping users generate formulas or answer questions, but it wasn’t integrated into Excel’s core function system. That changes with the new COPILOT() function, which allows users to enter prompts directly into cells, combining natural language queries with highlighted data ranges for analysis. This is a significant shift, as it puts Copilot on the same level as formulas like AVERAGE() or VLOOKUP(), making it a more natural part of Excel’s workflow.
The new function is designed to provide deeper context to data by letting users enter both a prompt and a data range. For example, you could type =COPILOT("Classify this feedback", D4:D18) and Excel would categorize survey results or customer comments in real time. Unlike the existing Copilot interface, which only suggests functions or provides general guidance, this new feature allows for more direct integration with spreadsheet data. Microsoft says the tool can handle classification tasks, generate multi-row or multi-column lists, and even provide insights within the document itself. For now, it cannot pull in external live data or integrate with other documents, though those capabilities are planned for future updates.
There are some important limitations to note. Microsoft acknowledges that Copilot may occasionally omit rows in array results, and there are known issues with dates. To prevent system overload, usage is capped at 100 function calls per 10 minutes and 300 per hour. Users are also strongly encouraged to review Copilot’s outputs carefully, as AI-generated content may still contain errors. Currently, the function is only available to Beta Channel testers with a Microsoft 365 Copilot license, running Windows 11 version 2509 (191212.20000) or newer. More details are available through Microsoft’s official support pages, and as the rollout continues, this feature could reshape how Excel power users integrate AI into their day-to-day workflows.
