Excel makes everyday spreadsheet work easier without another Copilot feature

Microsoft is previewing three practical Excel changes, from easier non-merged formatting and table naming to experimental lists and arrays inside cells.

Microsoft is rolling out three small but practical Excel changes that should matter to anyone who uses the spreadsheet programme for real work, not just for charts and neat presentation. According to the How-To Geek report, the updates are being previewed gradually, so availability will vary by version and release channel. They are also notable for what they are not: none of them depends on Copilot or any other AI feature.

The first change makes one of Excel’s most useful formatting options easier to reach. Microsoft is adding “Centre Across Selection” to the drop-down menu beside Merge and Centre, which should reduce the number of users who default to merging cells simply because it is the easiest visible choice. That matters because merged cells can interfere with sorting, filtering and other data operations, whereas Centre Across Selection achieves a similar visual result without combining the cells themselves. Guidance from specialist Excel sites such as Analistable, Better Solutions and FormulaSmith has long recommended the feature for exactly that reason.

The second update brings table naming into the table-creation workflow itself. Instead of creating a table first and renaming it afterwards on the Table Design tab, users will now be able to assign a meaningful name in the Create Table dialogue. ExcelCampus has previously noted that this removes an extra step from a task many users already perform immediately, and it reinforces a broader best practice: table names should help explain the data, not merely satisfy a default setting. For people working in large workbooks, clear table names improve formula readability, make navigation easier through the Name Box, and help when building PivotTables, charts or Power Query queries.

The most ambitious change is also the most experimental. Microsoft is introducing lists and arrays inside cells, a move that challenges Excel’s long-standing assumption that one cell should hold one value. In the new model, a single cell can contain several items while still allowing those items to be searched or filtered individually. The company is also adding four functions to work with that structure: FLATTEN, HAS, HASANY and HASALL. According to the How-To Geek report, these tools are intended to let users inspect and manipulate nested data more directly, rather than forcing everything into separate columns or text strings.

That said, the feature is still limited. The report says nested array calculations rely on a new Compatibility Version 3 setting, which is not yet widely available, and Microsoft already lists several restrictions. Lists and arrays cannot yet be used as drop-down items for data validation, Find & Replace cannot edit individual items inside them, PivotTables cannot use array values as source data, and Power Query cannot load or output columns that contain arrays. Those caveats suggest the feature is aimed at future spreadsheet design as much as current day-to-day use.

Taken together, the updates point to a quieter but more useful direction for Excel. They improve formatting, reduce friction in workbook organisation and open up a new way of structuring data, all without depending on AI. For long-time users, that may be more valuable than another headline Copilot feature: it shows Microsoft is still addressing the everyday annoyances that shape how people actually work.