Microsoft Makes Long-Awaited UI Updates to Excel’s ‘Center Across Selection’ Feature

Microsoft is rolling out a series of user interface updates to Excel designed to make one of the application’s most useful formatting features significantly easier to find and use. For years, seasoned spreadsheet architects and data managers have championed "Center Across Selection" as a superior alternative to the ubiquitous "Merge & Center" button, yet the feature remained tucked away inside deep dialogue menus. Now, as part of a gradual preview rollout, Microsoft is finally surfacing the option directly on the primary Home tab, signaling a welcome shift toward refining everyday core functionality rather than solely focusing on advanced AI integrations.

The primary catalyst for this update centers on the notorious pitfalls associated with merged cells. While the Merge & Center button on the Excel ribbon is familiar, convenient, and visually appealing at first glance, it has long earned a reputation among data professionals for causing severe complications down the line. When users merge multiple cells together into a single block, they inadvertently create roadblocks for future data management tasks. Standard spreadsheet operations—such as sorting datasets, filtering information, applying advanced formulas, or converting a standard range of data into a structured Excel table—often break or trigger error messages when encountering merged cells. Furthermore, if a user attempts to merge a range that contains multiple distinct values, Excel’s safety protocols will automatically delete extraneous data to complete the merge, occasionally resulting in accidental data loss.

Despite these known risks, users frequently reach for Merge & Center to achieve specific aesthetic layouts, such as centering a primary worksheet title across several columns or displaying a spanning status message like "Closed" over a specific multi-column range to indicate a business closure. While the visual result satisfies the designer’s immediate goal, the underlying data grid becomes rigid and difficult to manipulate when the file eventually transitions from a simple layout into a complex analytical model.

Fortunately, Excel has long possessed a built-in feature that achieves the exact same visual presentation without altering the integrity of the underlying cells. Center Across Selection allows users to center text horizontally across a selected range of columns while keeping every individual cell entirely independent. For instance, a user can type text into the leftmost cell of a designated range, highlight the entire horizontal span, and apply the command. The text appears beautifully centered across the chosen columns, but the cells remain distinct entities. Because the cells are not actually merged, the dataset can be sorted, filtered, and structurally modified without triggering the errors typically caused by standard merging.

The historical barrier to widespread adoption, however, was purely ergonomic. Finding Center Across Selection previously required users to bypass the prominent ribbon button entirely, right-click to open the Format Cells dialog box, navigate to the Alignment tab, and manually locate the Center Across Selection option within the Horizontal drop-down menu. For everyday spreadsheet users, this multi-step navigation proved too cumbersome, driving them back to the convenient but hazardous Merge & Center button out of sheer habit.

Recognizing this friction, Microsoft has integrated the Center Across Selection option directly into the existing Merge & Center drop-down menu located on the Home tab of the Excel ribbon. Because this update is currently rolling out as a preview feature, the exact deployment timeline and visibility may vary across different user accounts and versions of Microsoft 365, but its inclusion marks a significant usability win. Notably, the command functions strictly horizontally across rows rather than vertically down columns, a limitation that experienced data managers view as a positive safeguard, given that vertical cell merging is rarely recommended in professional data architecture.

Another major advantage of Center Across Selection is its compatibility with Excel tables. While traditional merged cells are strictly prohibited within the body of an established Excel table, Center Across Selection can be applied seamlessly within table rows. This allows users to maintain all the automated formatting, structured referencing, and dynamic sizing benefits of Excel tables without sacrificing their preferred layout designs. The only exception remains the table header row, where individual columns require distinct, unshared headers to function properly.

Beyond its new home in the ribbon drop-down menu, power users can now incorporate the command into the Quick Access Toolbar with minimal effort. Previously, adding Center Across Selection to the Quick Access Toolbar required complex workarounds or Visual Basic for Applications scripts because the command was buried deep within formatting menus. With the updated interface, users can simply right-click the option within the Merge & Center menu and select the prompt to add it directly to the Quick Access Toolbar, placing the command permanently at the top of the workspace for instantaneous access.

This enhancement is part of a broader recent push by Microsoft to improve longstanding, foundational features within Excel. Alongside the updated menu options for text alignment, recent updates include the ability to define table names at the moment of creation, as well as the introduction of several powerful new functions designed to streamline how users manipulate lists and arrays within cells. After a prolonged period heavily dominated by Copilot-centric updates and artificial intelligence rollouts, these targeted refinements to core spreadsheet mechanics offer a refreshing change of pace for professionals who rely on Excel’s day-to-day reliability.