Formulas & Functions•2 min read
Excel June 2026 Update: All New Features Explained
Microsoft added new features to Excel in June 2026. See what changed, from new functions to performance improvements.
SheetHub••2 min
Microsoft pushed a significant update to Excel in June 2026. Several new features, functions, and performance improvements rolled out to Microsoft 365 subscribers. Here is what changed and why it matters for your daily work.
The biggest news is the general availability of GROUPBY and PIVOTBY — two functions that let you create aggregated reports with formulas instead of Pivot Tables.
GROUPBY groups data by one or more columns and applies an aggregation:
PIVOTBY adds column grouping for cross-tabulation:
These functions spill results dynamically and update instantly when source data changes — no refresh button needed.
Microsoft redesigned the calculation engine for array formulas. Spreadsheets with multiple GROUPBY, FILTER, and SORT formulas now calculate up to 40% faster compared to the January 2026 release.
The improvement is most noticeable on datasets with 50,000+ rows. Users reported that complex dashboards that previously took 8-10 seconds to recalculate now complete in under 5 seconds.
Several existing functions received argument updates:
XLOOKUP now supports a
The web version of Excel now supports:
Update your templates. If you use Pivot Tables for reporting, test GROUPBY as a replacement. The formula approach is faster and more portable.
Check your Excel version. These features require Microsoft 365 (version 2506 or later). Go to File → Account → About Excel to check.
New Functions: GROUPBY and PIVOTBY
=GROUPBY(Products[Category], Products[Sales], SUM)=PIVOTBY(Products[Region], Products[Category], Products[Sales], SUM)Performance Improvements
Updated Function Arguments
search_algorithm parameter that lets you choose between binary search and linear search for large datasets.
TEXTBEFORE and TEXTAFTER gained an instance_num parameter that accepts negative numbers — -1 finds the last occurrence instead of the first.
Excel for Web Improvements
- Real-time co-authoring with formula suggestions
- Inline images in cells (previously desktop-only)
- Local file autosave to OneDrive without manual upload
Pro Tips
Related Articles
- GROUPBY Function Guide — Complete guide to Excel's new aggregation function
- XLOOKUP Complete Guide — XLOOKUP with the new search_algorithm parameter
- Google Sheets Updates — What Google added to Sheets this year
Recommended Next Reading
Excel
=EXCEL(...)Excel ROUND Function: MROUND, CEILING & FLOOR Guide
Explore ↗
Excel
=EXCEL(...)Excel LAMBDA Recursive Loops: Advanced Calculations
Explore ↗
Excel
=EXCEL(...)Excel REGEXEXTRACT: Extract Patterns and Substrings
Explore ↗
Share this tutorial
Discussion & Community
Share questions, tips, or edge-cases about this spreadsheet formula.