New Features in Excel.

Insider program 2026

  • Auto-refresh Pivot Table
  • IMPORTCSV and IMPORTTEXT
  • COPILOT – Returns the response based on your referenced data using an AI model.

AI-Powered Excel

  • Claude – An integrated assistant that supports analysts and modellers with explanations, formula help, and modelling guidance.
  • Agent Mode– Automates complex, multi‑step tasks by chaining actions together.
  • AI-Powered Python – Creates Python scripts directly from natural‑language prompts for analysis, automation, and visualisation.
  • Integrating Copilot– Brings Microsoft Copilot directly into Excel for intelligent suggestions, formula creation, and data insights.
  • Formula by example – Automatically fills in formulas based on patterns you demonstrate, similar to Flash Fill but for calculations.
  • Enhanced Data Cleaning – Improved tools for detecting errors, fixing inconsistencies, and preparing messy datasets more efficiently.

2025

  • REGEXEXTRACT, REGEXREPLACE, REGEXTEST – Returns the (characters, text, boolean logic) that match the pattern provided
  • TRANSLATE – Translated into another language.
  • TRIMRANGE–  Returns array, excludes all empty rows and/or columns from the outer edges of a range or array.​​​​​​​​​​​​​

2023

2022

  • TEXTSPLIT, TEXTBEFORE, TEXTAFTER – Returns the text string split into multiple columns using delimiters.
  • VSTACK, HSTACK – Combine ranges vertically (horizontally) in sequence
  • WRAPCOLS, WRAPROWS – Returns array transformed into multiple columns (rows)
  • TOCOL, TOROW – Convert range to single column (row)
  • DROP – Returns the array without certain rows or columns.
  • TAKE – Returns the intersection of specific rows and columns in an array.

2021

  • BYCOL, BYROW – Applies a LAMBDA to each column/row and returns an array of the results.
  • SCAN – Returns the array after applying a LAMBDA function to each value and returns an array.
  • MAP – Returns the array formed by applying a map using a LAMBDA function.
  • REDUCE – Returns the total value after reducing an array by applying a LAMBDA function.

They are available in Excel 365 or Excel 2021 and later.

2020

  • LABDA, LED – Returns the results of a formula added as a named range.

2019

Dynamic Array Formulas are Excel formulas that can return arrays of variable size based on a single formula entered in one cell. Unlike traditional Array Formulas, which require a special keystroke combination Ctrl+Shift+Enter, DAF are entered in one cell and confirmed with ENTER only.

Spill – refers to a behaviour where dynamic array formulas that return multiple results “spill” these results into multiple cells automatically.

Spill array – refers to the range of values returned by a dynamic array formula that spills results onto a worksheet. Once you enter a spilled array formula, when you select any cell within the spill area, Excel will place a highlighted in blue border around the range. The border will disappear when you select a cell outside of the area.

  • FILTER  – Returns the array based on the criteria you define.
  • UNIQUE  – Returns unique items from a range if cells.
  • SORT  – Sort a table (or range) by column or row.
  • SORTBY  – Sort a table (or range) by another list.
  • SEQUENCE – Generates an array of sequential numbers.
  • RANDARRAY  – Generates an array of random numbers.

New Errors:

  • #SPILL!– An error resulting from the fact that the dynamic array cannot spill because there is a non-empty cell in the area.
  • #CALC! – An error occurs when Excel’s calculation engine encounters a scenario it does not currently support.

Spill Operators (#) Can be used with dynamic array functions to reference the entire range of values that a formula spills into.