What COPILOT does
=COPILOT brings prompting into the worksheet grid. Instead of asking Copilot only from a sidebar, you can place a natural-language instruction directly in a cell and have Excel return generated output there.
This makes the feature useful for lightweight categorization, text cleanup, draft summaries, column-by-column labeling, and other tasks where you want AI output to behave more like a formula result.
Practical examples
Generate a category from text
=COPILOT("Assign a short category for this customer request", A2)
This can be useful when a column contains messy support notes or freeform text and you want a first-pass label.
Summarize a value or range
=COPILOT("Summarize the main trend in one sentence", B2:B20)
When the feature is available in your environment, this pattern can turn a small block of worksheet data into a short summary directly in the workbook.
Common mistakes and notes
Availability is not universal
=COPILOT is a modern Microsoft 365 feature and availability can change by build, preview channel, license, tenant policy, and platform. If the function is missing, the issue may be product availability rather than formula syntax.
Treat output as draft content
Because the result is AI-generated, it still needs review. This matters especially when you use the function for analysis, categorization, or any workbook that drives business decisions.
Structured data helps
Like other Copilot workflows in Excel, the function tends to work better when the referenced cells are clear, labeled, and consistent.