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

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

Audit your GA4 account in Minutes

Audit your GA4 account in Minutes

Sponsored
GA4 Auditor
GA4 Auditor

Verified Sponsor

Verified Sponsor

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

Verified Sponsor
BigQuery Launches Gemini-Enhanced SQL Translation Features

BigQuery Launches Gemini-Enhanced SQL Translation Features

Google Cloud
Google Cloud

Official Source

Official Source

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

Official Source
Google Analytics Introduces Data Access and API Quota Monitoring Features Trending ️‍πŸ”₯

Google Analytics Introduces Data Access and API Quota Monitoring Features

Google
Google

Official Source

Official Source

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

Official Source
Google Tag Manager Updates Conversion Linker with Local Storage Support

Google Tag Manager Updates Conversion Linker with Local Storage Support

Google
Google

Official Source

Official Source

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

Official Source
Amazon Ads Introduces Dynamic Segments for Improved Ad Targeting

Amazon Ads Introduces Dynamic Segments for Improved Ad Targeting

Amazon Ads
Amazon Ads

Official Source

Official Source

Amazon Ads 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