Microsoft Introduces Python Editor in Excel for Beta Users

Microsoft's Python Editor is now available directly in Excel for Beta testers, adding a dedicated coding space within the UI.

Microsoft has introduced a Python Editor within Excel, exclusively for individuals enrolled in the Microsoft 365 Insider program’s Beta channel. This new feature, transitioning from a previously optional Excel Labs add-in, is now part of the Microsoft Excel core interface. Users can find this feature in the Formulas tab, accessible via a new Editor icon next to the Insert Python icon.

Enhanced User Interface and Features

The Python Editor in Excel maintains a user-friendly design similar to its original form. This tool allows users to handle Python cells in their spreadsheets much like Jupyter notebook code cells. Users can edit, run, and view outputs, which are displayed directly within the spreadsheet.

It accommodates various output formats, such as plain text, numeric data, visualizations, and DataFrames. Additional functionalities like Intellisense, syntax highlighting, and function assistance are provided to streamline coding within Excel. This enhanced workspace lets users manage larger code blocks more effectively.Python-Editor-Excel-Action-Microsoft

Functionality and User Experience

This integration allows each Python cell to act as a code cell, enabling in-place code editing and execution. Outputs are displayed natively within the spreadsheet, supporting a wide range of data types and visual presentations. The editor incorporates Intellisense and syntax highlighting to assist users in writing and troubleshooting Python scripts. Additionally, users have the option to draft code and decide when to integrate it into the spreadsheet, providing enhanced control over their projects.

Current Availability and Future Prospects

Currently, the Python Editor is accessible to Microsoft 365 Insider Beta users. Those not part of the Insider program can still access it as an add-in via Excel Labs. No timeline has been announced for its general release to all Windows users. The initial support for using Python in Excel began in June for Enterprise, Business, Education, and Family and Personal users on Windows Current Channel (Preview) builds under Version 2406 (Build 17726.20016).

Last Updated on November 7, 2024 3:38 pm CET

SourceMicrosoft
Luke Jones
Luke Jones
Luke has been writing about Microsoft and the wider tech industry for over 10 years. With a degree in creative and professional writing, Luke looks for the interesting spin when covering AI, Windows, Xbox, and more.

Recent News

0 0 votes
Article Rating
Subscribe
Notify of
guest
0 Comments
Newest
Oldest Most Voted
Inline Feedbacks
View all comments
0
We would love to hear your opinion! Please comment below.x
()
x