cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Excel Blog

Subscribe to the Excel Blog to get the latest product announcements and updates
Options
16.2K

What's New in Excel (March 2024)

Microsoft Excel on Mar 26 2024 09:30 AM
Export to CSV, show details in PivotTables, Power BI-connected tables, and more
10.4K

Office Scripts is now available for Office 365 Enterprise E1 and Office 365 F3 licenses

isabeladominguez on Mar 18 2024 11:25 AM
We are happy to announce that Office Scripts in Excel is now available for customers with Office 365 Enterprise E1 and O...
24.8K

What's New in Excel (February 2024)

Microsoft Excel on Feb 27 2024 01:05 PM
Chart data task pane, images and data types in PivotTables, and new default theme
33.6K

What's New in Excel (January 2024)

Microsoft Excel on Jan 30 2024 03:32 PM
Sync Forms data to the Excel for the web, date picker, and expanded PivotTables functionality in Excel on iPad, and more
28.2K

Introducing PivotTables on iPad

GraceOued on Jan 04 2024 06:00 AM
Create and edit PivotTables on iPad.
23.7K

2023 in Review

Microsoft Excel on Dec 19 2023 06:00 AM
Thank you for an incredible 2023 filled with excitement, innovations, and delights
27.9K

A new way to debug formulas from Excel Labs

jack-williams on Dec 11 2023 06:00 AM
Formula debugger in Excel Labs
40K

What's New in Excel (November 2023)

Microsoft Excel on Nov 28 2023 11:20 AM
GROUPBY, PIVOTBY, trendline equation formatting and more
74.5K

New aggregation functions: GROUPBY and PIVOTBY

JoeMcDaid on Nov 14 2023 01:11 PM
The new GROUPBY and PIVOTBY functions allow you to perform data aggregations using just a formula.
48.4K

What's New in Excel (October 2023)

Microsoft Excel on Oct 31 2023 01:41 PM
Checkboxes, data conversion control, web connector and more!
30.2K

Introducing New Enhancements to the Web Connector in Excel for Windows

jokahati on Oct 26 2023 06:00 AM
Import data from website and use new table detection tools to quickly structure and model your data.
23K

Enhance Your Excel for the Web Experience with New Formula Authoring Features!

Nir_Tal on Oct 25 2023 06:00 AM
New formula authoring capabilities in Excel for the Web help make creating and correcting formulas easier, enabling you ...
18.3K

Optimizing Narrator screen reader announcements in Excel for Windows

Sharon910 on Oct 24 2023 08:45 AM
New screen reader announcements in Excel help you navigate the grid more efficiently.
23.3K

Improve your productivity in Excel for the web with Power Automate!

ravon314 on Oct 05 2023 09:00 AM
Announcing the new "Automate Work" button in Excel for the web, powered by Power Automate
29.7K

What's New in Excel (September 2023)

Microsoft Excel on Sep 26 2023 03:43 PM
Python in Excel available to more Insider Beta users on Windows, Python Editor, Copilot support for Python in Excel, and...
40.7K

Introducing Copilot support for Python in Excel: Advanced Data Analysis Using Natural Language

David Monroy on Sep 21 2023 08:00 AM
Copilot in Excel will help you analyze and explore your data in a new way: writing Python code
37.1K

Introducing the Python Editor from Excel Labs

Chris_Gross on Sep 18 2023 09:00 AM
A new way to write and edit Python formulas in Excel
31.5K

What's New in Excel (August 2023)

Microsoft Excel on Aug 30 2023 09:03 AM
Python in Excel, Power BI connected tables, interactive PivotCharts in Excel web, and more
1.2M

Announcing Python in Excel: Combining the power of Python and the flexibility of Excel.

Microsoft Excel on Aug 22 2023 06:00 AM
Since its inception, Microsoft Excel has changed how people organize, analyze, and visualize their data, providing a bas...
23.1K

Excel’s Formula Bar Gets a New Look

Chris_Gross on Aug 18 2023 08:00 AM
Monospaced Formulas Learn how the latest update to Excel improves the readability and usability of the formula bar.
21.6K

Stale Value Formatting

JoeMcDaid on Aug 08 2023 12:36 PM
Stale Formatting is a significant improvement to one of spreadsheeting's oldest features - Manual calculation mode.
30.9K

What's New in Excel (July 2023)

Microsoft Excel on Jul 25 2023 11:14 AM
Check out what's new in Excel this month
27.8K

Spreadsheets in Space just became more powerful with a new API in Microsoft Excel

Chris_Gross on Jun 28 2023 06:00 AM
We are always looking for new ways to help people do more and create new experiences, so the Excel team was excited to c...
37.2K

What's New in Excel (June 2023)

Microsoft Excel on Jun 27 2023 06:00 AM
Check out what's new in Excel this month
25.7K

Introducing Formula Suggestions

Lev_Solodkin on Jun 26 2023 12:15 PM
Unlock the potential of Excel's Formula Suggestions and make writing formulas easier and faster!
18.3K

Happy Pride from Excel!

Microsoft Excel on Jun 16 2023 10:00 AM
Happy Pride from all of us here at Excel! Check out a special Show Your Pride theme and this Excel template to learn mor...
48.8K

What's New in Excel (May 2023)

Microsoft Excel on May 30 2023 12:42 PM
Check out what's new in Excel this month
20.7K

Working with our partners who build assistive technology

Sharon910 on May 18 2023 04:54 PM
Today we celebrate Global Accessibility Awareness Day. We're excited to integrate Immersive Reader and custom UI Automat...
33.2K

What's New in Excel (April 2023)

Microsoft Excel on Apr 25 2023 05:16 PM
Check out what's new in Excel this month
28.1K

4 Essential Conditional Formatting Tips to Make Your Data Pop

Microsoft Excel on Apr 19 2023 07:50 PM
Uplevel your Excel game with these tips for highlighting your data.

Latest Comments

jignesh0yt2k
in Announcing New Text and Array Functions on Apr 24 2024 12:15 AM
@Henn Sarv Thank you for your solution posting. See here the limitation of using TEXTJOIN (Solution posted by Scott Craner: https://stackoverflow.com/questions/76065555/how-to-use-textsplit-on-a-column-from-a-dynamic-array-spill-range-in-excel) It clarifies that "One note, TEXTJOIN does have a limit...
0 Likes
jignesh0yt2k
in Announcing New Text and Array Functions on Apr 24 2024 12:10 AM
@MeniPorat Thank you for posting your solution. I found the same here before that: https://stackoverflow.com/questions/76065555/how-to-use-textsplit-on-a-column-from-a-dynamic-array-spill-range-in-excel (posted on April 20, 2023) (Some other workaround options can also be found there) and from: http...
0 Likes
Henn Sarv
in Announcing New Text and Array Functions on Apr 23 2024 11:58 AM
The new browser UI don't allow me to read all the thread but ...I had similar problem with textsplit against dynamic arrays. THere is most simplest way to bypass this limitation1st =TextJoin this dynamic array and then textsplit this to multiarray. Works finemydynamic=array(Fist,LastFirst,Last...)=t...
0 Likes
jpspiegs
in New in Excel for the web: Power Query Refresh is now generally available for selected data sources on Apr 23 2024 09:45 AM
@jokahati , any updates on both authenticated refresh and "Refresh All" via Power Automate? It has been a few months since you indicated that it should be available soon, so just checking back. Thanks!
1 Likes
NeonGhost
in Announcing New Text and Array Functions on Apr 23 2024 09:29 AM
@ MeniPorat – many thanks for sharing this formula with me. That was very kind of you.
1 Likes