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
14.5K

Improved Name Manager in Excel for Mac

Steve_K_Excel on Feb 17 2022 12:46 PM
The new Name Manager in Excel for Mac now has all the capabilities you enjoy in Excel for Windows. This is something man...
57.1K

Announcing LAMBDAs to Production and Advanced Formula Environment, A Microsoft Garage Project

Chris_Gross on Feb 08 2022 08:55 AM
Today we are promoting LAMBDAs to production and releasing a new tool, Advanced Formula Environment, A Microsoft Garage ...
10K

Charting on the Web Feature Updates

Auston on Feb 03 2022 09:00 AM
Major upgrades to the charting experience in Excel for the Web.
60.1K

Speed up data entry and validation with AutoComplete for dropdown lists in Excel for Windows

Prash Shirolkar on Jan 31 2022 09:00 AM
(Photos courtesy of NASA) Today, we are excited to announce that speeding up data entry and validation with AutoComplete...
33.1K

New Conditional Formatting experience in Excel for the web

Avital Nevo on Jan 20 2022 06:45 AM
Try the new Conditional Formatting experience in Excel for the web today
34.4K

Excel 4.0 (XLM) macros now restricted by default for customer protection

CatPidge on Jan 19 2022 11:38 AM
Usage of Excel 4.0 (XLM) macros are restricted by default through the Trust Center Macro Settings.
15.3K

What’s New in Excel for the web (December 2021)

Avital Nevo on Dec 13 2021 10:00 AM
Searchable data validation list, Queries pane, text in shapes, and more
8,585

Open & Edit more files in Excel for the Web

GirishBaj on Dec 06 2021 10:00 AM
We are excited to share that you can now open and edit more files on the web and complete your job anywhere, in the brow...
76.2K

Meet Niko Chatzoudis, Excel Forum Contributor

cuong on Nov 18 2021 07:16 AM
Meet Niko Chatzoudis who believes in not only helping the user but also delighting them
12.7K

Feature Updates for Sheet View

Avani_Reddy on Nov 17 2021 10:00 AM
Learn more about our recent improvements to Sheet View, including the ability to hide rows and columns and our latest su...
5,070

Observable now integrates with Microsoft Excel Connector and O365/OneDrive Cloud Files

Kathy_Zhang on Nov 16 2021 10:00 AM
Observable's new integrations with Excel, O365, and OneDrive allow users to bring data from Microsoft sources to the Obs...
11.5K

Announcing the new Microsoft Feedback portal - accepting suggestions now!

Steve_K_Excel on Nov 10 2021 12:01 PM
We’re pleased to announce a new community feedback experience from Microsoft, where you can submit suggestions about Exc...
14.9K

Find All in Excel for Mac

Steve_K_Excel on Nov 09 2021 10:09 AM
We're excited to announce some improvements to the Find and Replace feature in Excel for Mac—you can now edit cells with...
22.4K

Announcing Data Types APIs: Data Types in Excel Add-ins

Chris_Gross on Nov 03 2021 09:00 AM
Have you ever wanted to create a solution which combines the power of data types in Excel with a specific service or dat...
18K

Announcing buttons for Office Scripts: Run scripts with a workbook button

NancyatMSFT on Nov 02 2021 10:42 AM
Starting today, you—and your colleagues—can run Office Scripts by pressing a button within a workbook. This highly reque...
15.4K

Excel for the web: Evolution from companion app to collaboration powerhouse

Avital Nevo on Oct 29 2021 10:00 AM
How Excel for the web has evolved into a full-featured modern spreadsheeting experience
120K

Smooth Scrolling comes to Excel for Windows

Steve_K_Excel on Oct 07 2021 11:54 AM
We’ve improved scrolling in Excel for Windows! Read the post for details.
14.3K

Excel and Power BI: connected features coming soon for users with Power BI free licenses

David Monroy on Aug 31 2021 10:00 AM
Connected PivotTables and Organization data types in Premium Capacity coming soon for users with Power BI free licenses
6,247

Help us shape the future of automation in Excel

NancyatMSFT on Aug 17 2021 12:45 PM
Do you use automations in your spreadsheets? Take this five-minute survey to help the Office Scripts team decide on our ...
21.1K

Inspiration for inclusive features comes from customers

Sharon910 on Jul 29 2021 09:51 AM
Introducing Navigation pane in Excel, to make finding content and navigating within Excel easier for everyone. Navigatio...
73.6K

Announcing LAMBDA Helper Functions: Lambdas as arguments and more

Chris_Gross on Jul 26 2021 07:00 AM
Today we are releasing to our Beta customers seven new functions which make use of LAMBDA and also progressing LAMBDA to...
234K

Restrict usage of Excel 4.0 (XLM) macros with new macro settings control

Auston on Jul 22 2021 12:26 PM
New setting to individually configure XLM macro behavior now available via the Trust Center Macro Settings. Users can no...
4,299

Celebrate World Orca Day with Microsoft Excel

Sharon910 on Jul 14 2021 08:36 AM
Learn key data literacy concepts while exploring data about Kiki and her family of endangered Southern Resident orcas wi...
21.1K

What’s New in Excel for the web

Danielle_Rifinski on Jun 15 2021 10:00 AM
Text to columns, PivotTable improvements, Sort improvements, and more  
5,335

Come join our Office Scripts and Power Automate AMA!

NancyatMSFT on Jun 03 2021 01:56 PM
Save the date for our Office Scripts and Power Automate Reddit AMA on June 10 from 11 am - 12 pm PT.
70.2K

Office Scripts is now generally available in Excel for the web

petraronald on May 27 2021 04:40 AM
We are happy to announce that Office Scripts in Excel for the web is now generally available for all eligible users!
29K

Import data from local files using Power Query in Excel for Mac

Inbar_Privman on May 19 2021 10:00 AM
Import data from local files using Power Query in Excel for Mac now available to Beta channel users
14.5K

Our journey to make Excel work well for everyone

Sharon910 on May 05 2021 10:30 AM
Making Excel more accessible  
38.5K

Power BI connected PivotTables in Excel for the web

yunling on May 04 2021 10:00 AM
Power BI connected PivotTables in Excel for the web now available  
66.6K

Collaborate with confidence: Introducing Show Changes for Excel on the Web

Sanjay Bhat on Apr 29 2021 08:50 AM
Show Changes revolutionizes the collaboration experience in Excel for the web, tracking edits at the cell level.

Latest Comments

jignesh0yt2k
in Announcing New Text and Array Functions on Apr 24 2024 09:13 PM
@Peter Bartholomew Thank you for the details and your innovative solution, although frankly, I have yet to catch up with these new functions and more particularly their interface, interactions and nesting which you have displayed above, quite beautifully. I am just a starter yet.Just to elaborate in...
0 Likes
Peter Bartholomew
in Announcing New Text and Array Functions on Apr 24 2024 09:08 AM
@jignesh0yt2k This is just part of the ongoing battle with the new functionality (Lambda helper functions especially), coercing them to deal adequately with problems involving 'arrays of arrays' (that is normal spreadsheet models). If, as in Hitchhikers Guide to the Galaxy, the answer to your proble...
1 Likes
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