Excel Finally Lets You Put Multiple Values in a Single Cell

Microsoft is adding support for multiple values in a single cell to Excel, and the company has explained how the capability works. For as long as Excel has existed, the rule has been simple: one value per cell. That’s been a real source of frustration for anyone who’s ever needed to store several entries in one place, and the request to break that restriction has been one of the most persistent asks on Microsoft’s feedback channels. Now, that’s finally changing.

What Microsoft is actually changing

The update lets a single cell hold more than one value at a time. Instead of forcing everything into a single text string or spreading data across adjacent cells, you can now place several distinct entries in the same cell.

In practice, this is a meaningful shift from the traditional one-value-per-cell model. Historically, people who needed multiple values in one cell had to work around the limitation – combining entries with commas, semicolons, or line breaks, or using separate columns for each value. Those workarounds made the data harder to read, sort, and analyze.

With native support, those values live in a single cell without needing manual separators or extra formatting, which is the core of what Microsoft is changing here.

A person working at a desk, viewing an Excel spreadsheet on a monitor, thinking about organizing data. Warm office light — Users have long wanted multiple values per cell to keep their spreadsheets tidy.

How the feature works

According to Microsoft’s explanation, the new capability lets a cell accept more than one value. Rather than typing one entry and moving to the next cell, you can add several values in the same cell.

The company said it has provided details on how to use the feature, though the exact input method will depend on your version and setup. Depending on how you’re entering data – through a dropdown, a text field, or another input path – the experience may look slightly different from one scenario to the next.

What matters most is the underlying change: a cell is no longer restricted to a single value, which opens up new ways to organize information without the old workarounds.

The long road to multi-value cells

The push for multiple values in a single cell has been a staple of Excel feedback requests for years. On Microsoft’s feedback hub, the ask has repeatedly gathered strong support from users who build catalogs, tag lists, and other data-heavy spreadsheets.

Those users have long wanted to avoid the clunky workarounds of the past. Combining entries with delimiters means extra steps to separate them later, and splitting data across columns makes tables wider and harder to manage, especially as lists grow.

This feature, when it lands, would address that demand directly – letting people store multiple values cleanly in one cell rather than juggling separators and extra formatting.

A stylized illustration of a dropdown list expanding into multiple selected tags inside one cell, on a light background. — The new capability lets several entries share one cell without messy separators.

What this means for you

For everyday Excel users, the change removes a familiar limitation. If you’ve ever juggled multiple entries in one cell, you know how quickly that data can become messy and hard to work with, especially when you need to filter or sort it.

With native support, those values should be easier to read and manage. It could also simplify how you build lists of tags, categories, or options in a single cell, without the formatting gymnastics of before.

From an organizational standpoint, it means less time spent cleaning up delimiter-based entries and more time working with the data itself – a small change that adds up across large spreadsheets.

How to get it

The feature is arriving with a future update to Excel. To make sure you receive it as soon as it’s rolled out, keep Excel updated through Windows Update and the standard Office update channels so you don’t fall behind on Microsoft’s release schedule.

If you want early access before the wider release, you can join the Office Insider program, which gives testers access to new features ahead of the general public. That’s the typical path Microsoft uses to ship experimental capabilities and gather feedback before a full launch.

Source: Neowin

Over to you: How would you use multiple values in a single cell in your own spreadsheets – tags, categories, or something else entirely?