Microsoft Advances Python Editor in Excel to Beta, Enhances Usability and Design

July 15, 2024 at 6:49:07 AM

TL;DR Microsoft has advanced its Python Editor for Excel to beta status, enhancing its design, usability, and editing space. Initially an opt-in feature, it is now available to all users with the extension. The editor allows writing and editing Python formulas with features like Intellisense and function help. It displays Python cells in execution order and outputs directly in Excel. The editor is available in Excel version 2406 or later on Windows.

Microsoft Advances Python Editor in Excel to Beta, Enhances Usability and Design

Microsoft has advanced the Python Editor in Excel to beta status, enhancing the Python in Excel experience. Initially tested in August, this feature allows cloud-based Python calculations within Excel. Now available to all users with the extension, the beta version offers improved design, usability, and a larger editing area. Python support is available for Excel version 2406 or later on Windows.

Key Features and Enhancements

  • Integrated Python Editor: Initially an opt-in feature in Excel Labs, now available as an in-the-box option.
  • Improved Usability: Enhanced user interface and larger editing space for writing larger code blocks.
  • Productivity Features: Includes Intellisense, colorization, and function help, similar to Python notebook environments.
  • Execution and Output: Python cells can be edited and run within the editor, with outputs displayed natively in Excel, including text, numeric data, visualizations, and DataFrames.

excel python

Benefits of the Python Editor

  • Code Execution Flow: Shows Python cells in execution order and their outputs, aiding in debugging and understanding code.
  • Editing Longer Code: Provides a more immersive experience for working with longer scripts.
  • Flexible Workflows: Allows code writing and editing without immediate commitment to Excel, offering more control and faster feedback loops.

excel python cells

Access Requirements

To use the Python Editor, users need access to Python in Excel. Further details on access can be found in on Microsoft website here.

Q&A

Have more questions on this topic? Ask our AI assistant for in-depth insights.

Read more from sources πŸ‘‡

The Only Digital Marketing Feed You'll Ever Need.

Stay informed your way. Tailored updates when and how you want them. 100% Free.

10,000+ Users

500+ Sources

1000+ Tools

Or

Related Posts

Top-Notch Google Analytics Audit Tool

Top-Notch Google Analytics Audit Tool

Sponsored
GA4 Auditor
GA4 Auditor

Verified Sponsor

Verified Sponsor

GA4 Auditor is a Verified Sponsor. Want to get featured here? Contact us.

Verified Sponsor
Microsoft Launches Copilot Pages, Enhances AI in Excel, PowerPoint, and Teams Trending ️‍πŸ”₯

Microsoft Launches Copilot Pages, Enhances AI in Excel, PowerPoint, and Teams

AI Copilot +1 more
Microsoft
Microsoft

Official Source

Official Source

Microsoft is a Official Source. The source has been verified by Swipe Insight team.

Official Source
Microsoft Rolls Out Sleek New Look for Excel on the Web

Microsoft Rolls Out Sleek New Look for Excel on the Web

Microsoft
Microsoft

Official Source

Official Source

Microsoft is a Official Source. The source has been verified by Swipe Insight team.

Official Source
How to Back Up Universal Analytics in GA? - Export Your Data

How to Back Up Universal Analytics in GA? - Export Your Data

Google Analytics Integrates Customer Match with Remarketing Audiences Trending ️‍πŸ”₯

Google Analytics Integrates Customer Match with Remarketing Audiences

Google
Google

Official Source

Official Source

Google is a Official Source. The source has been verified by Swipe Insight team.

Official Source
LinkedIn Launches AI-Powered Lead IQ and Enhanced Account IQ for Sales Navigator

LinkedIn Launches AI-Powered Lead IQ and Enhanced Account IQ for Sales Navigator

LinkedIn
LinkedIn

Official Source

Official Source

LinkedIn is a Official Source. The source has been verified by Swipe Insight team.

Official Source
Bid Manager API Now Includes Lower Confidence Reach Data

Bid Manager API Now Includes Lower Confidence Reach Data

Google for Developers
Google for Developers

Official Source

Official Source

Google for Developers is a Official Source. The source has been verified by Swipe Insight team.

Official Source
YouTube Introduces Gifts System and Updates Member Hub Experience

YouTube Introduces Gifts System and Updates Member Hub Experience

Creator Insider
Creator Insider

Official Source

Official Source

Creator Insider is a Official Source. The source has been verified by Swipe Insight team.

Official Source

Related Tools

GA4 Auditor logo

GA4 Auditor

Verified Tool

Verified Tool

GA4 Auditor is a Verified Tool. Want to get this badge? Contact us.

Verified Tool

Automated GA4 audits with actionable insights

Get Featured Here

Showcase your tool in this list.

Contact Us
Formula Bot logo

Formula Bot

AI-powered data analysis and visualization tool

Data Analysis
Funnel logo

Funnel

Aggregate and analyze marketing data seamlessly

Reporting
Make logo

Make

Visually automate workflows without coding limits

Workflow Automation
Power My Analytics logo

Power My Analytics

Automate and integrate your marketing data

Reporting
Improvado logo

Improvado

Automated marketing data integration and analytics

Reporting
Supermetrics logo

Supermetrics

Unify marketing data for smarter decisions

Reporting
Grist logo

Grist

Relational spreadsheet-database for flexible data management

Data Analysis
DataSquirrel.ai logo

DataSquirrel.ai

Automated Data Insights for Non-Tech Managers

Data Analysis
Zapier logo

Zapier

Automate workflows across 7,000+ apps

Workflow Automation

Get Featured Here

Showcase your tool in this list.

Contact Us