Excel Cells Reimagined: Whats New

Key insights

• Lists (beta): A recent tutorial demonstrates a new Excel feature that lets a single cell store multidimensional arrays instead of one value. This change is in the Microsoft Insiders beta and is rolling out gradually.
  
• Ctrl+J and classic formulas: Use the Ctrl+J shortcut to convert delimited text or numbers into in-cell lists. Existing functions like COUNTA, SUM, SORT, and XLOOKUP adapt to work with these lists automatically.
  
• New functions: Five array-focused tools make lists practical: HAS (check if a value exists), HASALL (require all values), HASANY (require any value), FLATTEN (split list items into rows), and GROUPBY (summarize lists for reporting).
  
• Show Changes and the Changes pane: Excel now shows recent edits with editor, location, time, and previous values. You can filter by sheet, range, or cell. The pane tracks not only values but also formulas and structural edits. For long-term audits, use Version History instead.
  
• Practical benefits: The features speed up review, improve accountability, make rollback decisions easier, and strengthen co-authoring for teams working in Microsoft 365 environments.
  
• Limitations and tips: The Changes pane shows recent edits only and depends on co-authoring and where the file is stored. You can clear web history from File > Info. Test the new list features on copies, expect a gradual rollout, and rely on Version History for deeper audits.
  

Introduction

Leila Gharani [MVP] presents a concise YouTube tutorial that announces a significant shift in Excel’s cell model, currently rolling out in the Microsoft Insiders beta channel. In her video, she demonstrates how a single cell can now store multidimensional arrays using the new Lists feature, and she shows the practical shortcut to enable it. Consequently, this update promises to change how users handle delimited text and grouped values inside sheets.

Moreover, Gharani explains that the change includes both compatibility with many existing formulas and five brand-new functions created to work with in-cell lists. She demonstrates the new shortcut Ctrl+J to toggle standard text into list arrays and walks viewers through examples that reveal immediate workflow benefits. As a result, analysts and project managers may find repetitive text parsing tasks much simpler.

What the Feature Does

At its core, the update lets a single cell contain a list of values that behave like a small array, rather than only a single scalar value. Leila shows how classic Excel functions such as COUNTA, SUM, SORT, and XLOOKUP already adapt to operate on these in-cell arrays, which means many spreadsheets will require fewer intermediate columns. Therefore, the change reduces clutter and preserves context by keeping related values together.

Additionally, the video highlights five new functions designed specifically for lists: HAS, HASALL, HASANY, FLATTEN, and an enhanced GROUPBY. HAS checks whether a list contains a specific item, while HASALL and HASANY test for multiple values simultaneously. Meanwhile, FLATTEN expands grouped cell values into separate rows and GROUPBY summarizes lists for reporting tasks like counting projects per team member.

Impact on Common Workflows

For users who work with delimited text in trackers or financial reports, Gharani’s examples show how the new Lists feature eliminates manual text-to-column steps and many helper columns. She converts sample project team strings into lists and then uses built-in and new functions to filter, count, and extract unique items in place. Consequently, tasks that previously required multiple formula layers can now run with fewer moving parts and clearer structure.

Moreover, Leila demonstrates that existing formulas often adapt automatically, which reduces the migration burden for many worksheets. However, she also points out cases where explicit use of FLATTEN or GROUPBY is necessary to reshape data for pivot-style summaries. Thus, while the feature simplifies many daytime tasks, it also introduces new choices about when to keep lists in cells or expand them into rows.

Tradeoffs and Challenges

Despite the clear benefits, the update brings tradeoffs that teams must weigh carefully. For instance, storing many values in single cells can simplify layout, yet it may complicate auditing and long-term version comparisons if organizations rely on row-based history tools. Therefore, teams should consider how in-cell lists interact with their existing audit processes and version history practices.

Performance and compatibility present additional challenges because handling large nested lists could increase calculation time in complex workbooks, and not every client will see the feature until it reaches general availability. Furthermore, the functionality ties to co-authoring and Microsoft 365 environments, which means behavior can differ based on file storage and client versions. Consequently, coordinated rollouts and testing become essential to avoid unexpected results.

Practical Advice and Next Steps

Leila recommends that curious users try the feature in the Insiders beta to understand how it interacts with their core spreadsheets, and she demonstrates safe ways to test using copies of active files. Meanwhile, administrators should assess compatibility and plan phased adoption to measure any performance impacts in production workloads. As a result, teams can pilot the feature in non-critical workbooks before broader deployment.

Finally, users should balance convenience and clarity: keep lists in cells for quick, context-rich displays, but expand them with FLATTEN or use classic row-based layouts for intensive analysis and long-term auditing. In short, the change opens useful new patterns while requiring deliberate choices about structure, governance, and performance. Therefore, organizations will gain the most by combining careful testing with clear usage guidelines.

Keywords

Excel cells changed, Excel dynamic arrays, Excel spill formulas, Excel LAMBDA function, Excel LET function, Excel cell formatting tips, Excel update 2026, Excel cell references tutorial