Excel Adds Center Across Selection to Merge & Center Menu, Ending Merged Cell Headaches

It is not a brand-new calculation engine or an flashy AI assistant, and that is precisely why veteran spreadsheet users are celebrating. By bringing a long-buried formatting tool to the surface, Microsoft is finally making good spreadsheet hygiene as convenient as the bad habit it replaces.

Why Merge & Center Is a Data Trap​

To understand why a minor menu tweak matters so much to IT administrators, financial analysts, and everyday Windows power users, you have to look at what happens under the hood when you merge cells.

When you highlight a range—say, cells B2:E2—and click Merge & Center, Excel does not merely float your text over those four columns. According to Microsoft Support documentation, merging physically combines two or more adjacent cells into a single, larger cell. That structural alteration carries immediate consequences:

• Silent Data Destruction: Microsoft Support explicitly warns that when you merge multiple cells containing data, only the contents of a single cell survive (the upper-left cell for left-to-right languages, or the upper-right cell for right-to-left languages). Everything in the other merged cells is permanently deleted unless you copy it elsewhere beforehand.
• Broken Sorting and Range Manipulation: Spreadsheets rarely stay static. A simple visual schedule built on Monday often turns into an analytical dataset by Friday. When you attempt to sort a dataset entangled with merged cells, Excel throws errors or refuses to cooperate because the rows and columns no longer share a uniform grid structure.
• Incompatibility with Excel Tables: Converting a raw range into an official Excel Table is foundational for structured references, automatic formatting, and dynamic filtering. However, as Microsoft Support notes, the Merge & Center command is completely disabled inside formatted Excel tables, and existing merged cells get in the way when you try to convert a range into a table.

In short, Merge & Center prioritizes how a spreadsheet looks today at the expense of how it functions tomorrow.

Center Across Selection: Same Look, Intact Grid​

The antidote to merged cells has existed in Excel for decades: Center Across Selection. Instead of fusing cells together, this alignment command takes the text entered into the leftmost cell of a highlighted horizontal range and visually centers it across the span while leaving every individual cell completely separate.

If you type "Closed" into cell B2, highlight B2:E2, and apply Center Across Selection, the word sits neatly in the middle of those four columns. Yet if you click on C2, D2, or E2, they remain distinct, selectable cells. You can select individual columns without your cursor suddenly grabbing a massive multi-column block, and you can sort your rows without triggering structural errors.

As Exceljet's training documentation points out, there is one important practical rule to keep in mind: if the cells to the right within your selected span already contain text or values, Center Across Selection will not visually span across them until you clear those neighboring cells. Unlike Merge & Center, it refuses to destroy your adjacent data automatically—it simply waits for you to clear the path.

How-To Geek also highlights a major advantage for structured data users: because Center Across Selection is an alignment property rather than a cell-merging operation, you can apply it inside the body of a formatted Excel Table. The only place inside a table where it will not work is across multiple columns in the table's header row, since Excel requires every table column to maintain its own distinct header identifier.

Why Was It Hidden for So Long?​

If Center Across Selection is so clearly superior for data integrity, why has Merge & Center dominated office workbooks for thirty years? The answer comes down to user interface friction.

Until now, applying Center Across Selection required a multi-step detour:

1. Select the horizontal range of cells.
2. Open the Format Cells dialog box (either by right-clicking and choosing Format Cells, clicking the tiny dialog launcher arrow in the Ribbon's Alignment group, or pressing Ctrl + 1).
3. Switch to the Alignment tab.
4. Click the Horizontal drop-down menu.
5. Select Center Across Selection and click OK.

When users are rushing to format a financial summary five minutes before a meeting, five steps buried inside a legacy dialog box will lose to a giant, one-click button on the Home tab every single time.

Section Summary: While Merge & Center destroys neighboring cell values and breaks sorting and table structures, Center Across Selection achieves the exact same visual layout horizontally while keeping every cell independent. Its only real flaw was being buried deep inside the Format Cells dialog.

What Changed in the New Excel Update​

As reported by How-To Geek, Microsoft is now addressing this discoverability gap by placing Center Across Selection directly inside the Merge & Center drop-down menu on the Home tab. Instead of digging through modal dialog boxes, users can click the small arrow next to Merge & Center and pick the non-destructive alignment option right alongside legacy commands like Merge Across, Merge Cells, and Unmerge Cells.

One-Click Access via the Quick Access Toolbar​

For power users who format worksheets all day, even a two-click drop-down menu can feel like one click too many. Previously, because Center Across Selection lived exclusively inside a dialog box drop-down rather than as a discrete Ribbon command, pinning it to the Quick Access Toolbar (QAT) required writing and attaching a custom VBA macro.

With the command promoted to a first-class Ribbon menu item, How-To Geek notes that you can now add it to your toolbar natively:

1. Open the Home tab on the Excel Ribbon.
2. Click the drop-down arrow next to Merge & Center.
3. Right-click Center Across Selection in the menu.
4. Select Add to Quick Access Toolbar.

Once pinned to the QAT, applying—or removing—the alignment across a selected range takes a single click (or an Alt + Number keyboard shortcut corresponding to its QAT position), completely eliminating the convenience advantage that Merge & Center held for decades.

Step-by-Step: How to Use Center Across Selection (And Fix Old Workbooks)​

Whether you already have the new Ribbon menu option or are still waiting for the preview to reach your machine, transitioning your workflows is straightforward.

Applying Center Across Selection to New Ranges​

1. Type your heading or label into the leftmost cell of the horizontal range you want to span (for example, enter "Q4 Regional Forecast" in cell B2).
2. Ensure the adjacent cells are empty. Check that the cells to the right across your intended span (such as C2:E2) do not contain text or formulas, as existing content will block the visual centering.
3. Select the full horizontal range (B2:E2).
4. Apply the alignment:
   • If your build has the update: Click the Merge & Center drop-down arrow on the Home tab and select Center Across Selection.
   • If you are on an older build: Press Ctrl + 1 to open Format Cells, go to the Alignment tab, open the Horizontal drop-down, choose Center Across Selection, and click OK.

Rehabilitating Previously Merged Cells​

If you inherit a workbook riddled with merged headers that refuse to sort properly, you can convert them without losing the layout:

1. Select the merged cell range.
2. Click the Merge & Center button (or open its drop-down and choose Unmerge Cells) to split the range back into individual cells. As Microsoft Support notes, the surviving text will automatically sit in the leftmost cell.
3. While the range (B2:E2, for instance) is still highlighted from the unmerge action, immediately apply Center Across Selection via the drop-down menu, your QAT button, or Ctrl + 1.

Rollout Status and Platform Boundaries​

Before you go hunting for the new button on every device in your office, there are a few rollout boundaries to keep in mind:

• Gradual Preview Rollout: How-To Geek notes that Microsoft is rolling out this menu update gradually as a preview feature, meaning availability varies across update channels and tenants. In the Excel community on Reddit, users first began spotting the menu entry in mid-September 2026.
• Excel for the Web Limitations: If your organization relies strictly on browser-based Office apps, temper your expectations. According to a Microsoft Q&A support response from late December 2025, Center Across Selection was not supported in Excel for the web at all due to differences in the browser version's layout rendering engine. Microsoft has not yet published documentation confirming whether this desktop Ribbon update changes support in the web client.
• When Merge & Center Still Makes Sense: Notice that Microsoft only supports Center Across Selection horizontally across rows, not vertically down columns. As How-To Geek points out, avoiding vertical merges in data columns is smart practice anyway. Still, if you are building a static, printable form, a presentation-style dashboard, or a sign-in sheet where vertical labels are required and the grid will never be sorted or queried, Merge & Center remains in the menu for a reason.

Ultimately, great software design is about nudging users toward resilient habits without taking away their tools. After a year dominated by heavyweight Copilot announcements, seeing the Excel team smooth out a decades-old paper cut is a welcome win for everyday productivity. Have you spotted the new Center Across Selection option in your Excel Ribbon yet, or are you still surviving on Ctrl + 1 muscle memory? Share your build sightings and your worst merged-cell horror stories in the WindowsForum community threads!