What is New in Excel for September 2025



 Excel Blog:


🎉 Happy 40th Birthday, Excel! 🎉

Today, Excel turns 40—and we’re so excited to celebrate this milestone with you, our amazing community. For four decades, you’ve helped shape Excel into what it is today, and we couldn’t have done it without you.

Take a stroll down memory lane with our anniversary blog, explore 40 Days of Excel packed with tips and stories, and join the Excel team for a special Reddit AMA today at 10 AM PT.


This month, we’re thrilled to share some exciting updates! Agent Mode in Excel brings expert-level automation, refining results with AI so you can focus on guiding the outcome. The COPILOT function is rolling out to Excel for the web users soon through the Frontier program. We’re also bringing you formula completion with Copilot in Excel, making it easier than ever to work with formulas. And last but not least, the new Python Initialization Editor is now available to Insider users on Windows.

Excel for web​

Agent Mode in Excel

Agent Mode delivers AI that can “speak Excel” natively. It’s built on the richness of Excel artifacts and OpenAI’s latest reasoning models—democratizing access to expert-level capabilities and making advanced modeling approachable for most everyone. These breakthroughs allow Agent Mode to not only generate outputs, but also evaluate results, fix issues, and repeat the process until the outcome is verified. It’s like you’re handing off work to an Excel expert—while you steer and guide.  

An early preview of Agent Mode in Excel is available starting today via the Frontier program for Microsoft 365 Copilot licensed customers and Microsoft 365 Personal or Family subscribers (under the Microsoft Services Agreement). Agent Mode works in Excel on the web and is coming soon to desktop. To try it, install the Excel Labs add-in and choose Agent Mode (Frontier). Learn more about it in our announcement blog.


COPILOT function

The COPILOT function is here to help save you time and supercharge your workflows! Just enter a natural language prompt in your spreadsheet, reference cell values as needed, and watch Copilot instantly generate AI-powered results. This function is available to Insider users on Windows and Mac as well as Frontier web users. Read more here >

bS00NDQ4MzY4LVlXU0FQOA

GIF showing how the COPILOT function is built into Excel's calculation engine, updating your results automatically when the data changes.

Excel for web and Windows​

Formula completion with Copilot in Excel

When you type “=” in a cell, Excel analyzes the context of your workbook and suggests a formula completion suggestion, using the context of your worksheet - headers, nearby cells, formulas and tables. Alongside the suggestion you will see a preview of the result, as well as a short description in natural language of the formula’s intent. This is currently rolling out to production for Web users and also to Insider users on Windows. Read more here >

bS00NDQ4MzY4LUczMkFCUg


Excel for Windows​

Python in Excel: editable initialization pane (Insiders)

Take control of your Python environment—right inside your workbook. With the new Python Initialization Editor, you can customize how Python starts up to better suit your workflow. Easily view and modify the default initialization script, add your own imports, functions, or logic, and undo or reset changes as needed.

bS00NDQ4MzY4LWxPeldNbw


Excel for iOS​

Copilot-powered file previews (Insiders)

Unlock instant insights with Copilot-powered file previews in the Microsoft 365 Copilot app for iOS—just share a file and get summaries, answers, and intelligent suggestions in seconds. Read more here >

bS00NDQ4MzY4LXNzYmg4Zg


Many of these features are the result of your feedback. THANK YOU! Your continued Feedback in Action (#FIA) helps improve Excel for everyone. Please let us know how you like a particular feature and what we can improve upon—"Give a compliment" or "Make a suggestion"..  You can also submit new ideas or vote for other ideas via Microsoft Feedback.


 Source:

 
For all these fancy features, they ignore the most fundamental point about Excel i.e. that a good understanding of logic is still needed to develop complex spreadsheets regardless if a person describes the logic in words or in formulae.
 

My Computer

System One

  • OS
    Windows 11 Pro + Win11 Canary VM.
    Computer type
    Laptop
    Manufacturer/Model
    ASUS Zenbook 14
    CPU
    I9 13th gen i9-13900H 2.60 GHZ
    Motherboard
    Yep, Laptop has one.
    Memory
    16 GB soldered
    Graphics Card(s)
    Integrated Intel Iris XE
    Sound Card
    Realtek built in
    Monitor(s) Displays
    laptop OLED screen
    Screen Resolution
    2880x1800 touchscreen
    Hard Drives
    1 TB NVME SSD (only weakness is only one slot)
    PSU
    Internal + 65W thunderbolt USB4 charger
    Case
    Yep, got one
    Cooling
    Stella Artois (UK pint cans - 568 ml) - extra cost.
    Keyboard
    Built in UK keybd
    Mouse
    Bluetooth , wireless dongled, wired
    Internet Speed
    900 mbs (ethernet), wifi 6 typical 350-450 mb/s both up and down
    Browser
    Edge
    Antivirus
    Defender
    Other Info
    TPM 2.0, 2xUSB4 thunderbolt, 1xUsb3 (usb a), 1xUsb-c, hdmi out, 3.5 mm audio out/in combo, ASUS backlit trackpad (inc. switchable number pad)

    Macrium Reflect Home V8
    Office 365 Family (6 users each 1TB onedrive space)
    Hyper-V (a vm runs almost as fast as my older laptop)
@cereberus

@Brink

Most of this stuff can still be done (albeit you need to be a power user) with editions as far back as EXCEL 2010 although it's a lot more complex to derive the same solution but it can be done -- but of course nothing wrong in using new methodology that takes minutes to solve a problem rather than weeks.

The ancient Romans built fabulous aqueducts etc that have lasted for centuries (one of the most respected occupation for a Roman professional in the times of the Empire and Republic was that of the "Aquarius" or the engineer in charge of maintaining the public water supply and the building / reparing of their aqueducts).

However modern engineering could do this in days rather than years and doesn't need masses of people to do it either. That all said - I've nothing against using modern better methods -- but you are 100% correct in that the underlying problem needs to be understood before any solution can be derived.


a great read also (also available as an audio book too

Robert Harris -- Pompeii is the one on this subject. Great both as an audio book and as an e-book.


Cheers
jimbo
 

My Computer

System One

  • OS
    Windows XP,11 Linux Fedora Rawhide pre-release 45
    Computer type
    PC/Desktop
    CPU
    2 X Intel i7
    Screen Resolution
    4KUHD X 2

Latest Support Threads

Back
Top Bottom