Edit with Copilot in Excel to enhance your productivity (formerly Agent Mode)
[Windows, Web, Mac]
Edit with Copilot in Excel to build and change workbooks, using Excel tools like tables, charts, PivotTables, and formulas to complete complex data tasks faster.
Roadmap IDs:
542182
,
527835
Details:
What changed:
A new option is available in Copilot in Excel that enables you to edit your workbook through chat. You can use Copilot as an assistant to create and make changes by describing what you want to do through chat.
Why:
This change reduces the need to switch between manual steps and back-and-forth requests, which can help you move through data modeling and analysis with less effort.
Try this:
Open Copilot chat in Excel and see "Let's edit together" welcome message.
If you don't see the message, then go to the tools menu and select "Edit with Copilot".
Describe what you'd like to do in the chat. For example, "Build an expense tracking template, then add formulas for variance calculations."
Business impact:
Helps teams complete complex models and reports faster by reducing manual steps in Excel workflows.
Personal impact:
Saves you time by letting Copilot perform multi-step workbook updates while you stay focused on insights.