Excel now supports multiple values in a single cell
Microsoft Excel is introducing new functionalities, including lists, arrays in cells, and nested arrays, which allow users to store and organize multiple related values within a single cell. This update aims to simplify data management for tasks like project tracking and inventory lists, enabling better filtering, calculations, and analysis without spreading data across multiple rows or columns.
Why it matters
This is a significant quality-of-life improvement for Excel users, potentially streamlining complex data organization and analysis workflows, making the software more powerful and user-friendly for managing structured and semi-structured data.
Project trackers, surveys, inventory lists, and customer databases often contain related information that belongs together: multiple owners, tags, locations, or responses.
For years, organizing that information in Excel meant spreading it across additional rows and columns or combining everything into text that was difficult to work with.
Available today in Insiders Beta, lists, arrays in cells, and nested arrays introduce new ways to store and organize related information, helping you keep data together without sacrificing filtering, calculations, or analysis.
Let's explore these new functionalities in the context of a project tracker.
Each project may have multiple owners, workstreams, and milestones. Traditionally, you'd need separate columns, helper tables, or text like "Carlos, Henrietta, Jacob" packed into a single cell.
Get smarter about the news
Sign up free for a feed built around what you actually care about, Dive Deeper research on any story, and the full text of every article.
Create free accountAlready have an account? Sign in