Edit with Copilot in Excel 2026: Plan, Chat and Edit Modes (Plus Python on Demand)

For most of its life, Copilot in Excel lived in a side panel: you asked a question, it answered, and you copied the result across yourself. The April 2026 update changes that relationship. Copilot can now take direct action on the grid, and it gives you three distinct ways to work with it depending on how much control you want to keep. If you have spent years building spreadsheets by hand, this is the moment the assistant stops describing what to do and starts doing it.

Three modes: Edit, Plan and Chat

The headline change is a Chat/Edit switcher. In Edit mode (the new default), Copilot makes changes directly in the workbook – adding columns, writing formulas, cleaning data and building summaries on the cells themselves. In Plan mode, it first lays out a structured approach and waits for your nod before touching anything, which is ideal when the task is multi-step or the stakes are high. In Chat mode, responses stay contained in the conversation, exactly as before, for when you just want advice rather than action. The ability to choose your level of autonomy per task is what makes the feature safe to use on real work.

See the reasoning, then accept or undo

A long-standing worry with AI in spreadsheets is the black box: a number appears and you cannot tell where it came from. The 2026 release adds step-by-step reasoning so Copilot explains what it changed and why, and surfaces the edits it made so you can review them before keeping them. Because every action lands as a normal Excel edit, your usual Undo still works – nothing is locked away in a separate AI layer. The practical habit to build is simple: read the reasoning, spot-check one or two formulas, then accept.

Python on demand, without leaving the workbook

Edit with Copilot can now run Python directly. When a task needs more than native functions – a regression, a pivot-heavy reshaping, a chart that Excel does not draw natively – Copilot can apply Python-powered techniques as part of its edits, all inside the workbook. You do not need to know pandas to benefit, but if you do, it gives you a fast on-ramp to advanced analysis that previously meant exporting to a notebook. This pairs naturally with the standalone Python in Excel feature for users who want to write the code themselves.

Personalisation that learns your style

A new personalisation capability lets Copilot remember your formatting and logic preferences and apply them automatically. If you always format currency a certain way, prefer specific table styles, or structure summaries in a house format, Copilot starts matching that without being told each time. Over a few weeks this quietly removes a lot of repetitive cleanup.

How to get the most from it

Start in Plan mode for anything important so you can review the approach before changes land. Keep prompts concrete – name the columns, the sheet and the outcome you want. Always read the reasoning panel rather than trusting the output blindly, and verify totals against a figure you already know. Treat Copilot as a fast junior analyst whose work you check, not as an oracle. Used that way, it removes hours of mechanical effort while leaving the judgement – the part that matters – with you.

Key takeaways

• The April 2026 update adds a Chat/Edit switcher with three modes: Edit (acts directly), Plan (proposes first), and Chat (advice only).
• Copilot now shows step-by-step reasoning and surfaces its edits, and normal Excel Undo still applies.
• Python can run directly inside Edit with Copilot for advanced analysis without leaving the workbook.
• A new personalisation feature lets Copilot remember and reapply your formatting and logic preferences.
• Best practice: use Plan mode for important work, write concrete prompts, and always verify against a known figure.

Featured video: Copilot in Excel – The ULTIMATE 2026 Tutorial for Busy Professionals
Related sources: What's New in Excel (April 2026) – Microsoft Community Hub · Get started with Copilot in Excel – Microsoft Support · 11 cool things Copilot can do in Excel – Computerworld