Post actualizado el día octubre 27, 2026 by DeiviSanzPlay
You’re staring at an Excel sheet, you need a title that spans five columns, and you can’t find the damn button. Relax. The Merge Cells option in Excel lives on the Home tab, inside the Alignment group, and it’s been sitting there for over fifteen years. Microsoft has moved plenty of things around, but that one hasn’t budged. What confuses people isn’t the location, it’s the dropdown arrow hiding three other merge modes behind the icon.
The exact spot of the Merge Cells button in Excel
Open any version from Excel 2007 onward and look at the ribbon. Click Home, scan to the Alignment group, and you’ll see an icon showing small squares melting into one big square with a lowercase «a» inside. That’s your merge cells button in Excel. No menus, no digging, no add-ins.
The icon is split in two. Click the icon itself and Excel runs the default action: Merge & Center. Click the tiny arrow on its right and you get the full menu. Most people never touch that arrow, which is exactly why they think merge and center is the only option. It isn’t.
In Microsoft 365 and Excel 2021, 2019, 2016, and 2013, the path is identical. In Excel 2010 and 2007 you’ll also find it under Home > Alignment, just with a flatter, more schematic icon. Excel for Mac? Same story: Home tab, Alignment section, same dropdown.
Merge & Center vs Merge Cells vs Merge Across: pick the right one
Here’s where I’ll take a side. Merge & Center is overused and often the wrong choice. It joins the selected cells into one and centers the content, which looks great for a report title but destroys alignment when you’re building anything more complex.
Merge Cells joins the range without touching the text alignment. The content stays where it was in the top-left cell. If you’re formatting a dashboard or a table where text needs to stay left-aligned, this is the option you actually want.
Merge Across is the hidden gem. It merges cells in each selected row independently without joining the rows together. Select a 3×4 block, hit Merge Across, and you get three separate merged cells—one per row. Perfect for multi-row headers.
Unmerge Cells reverses everything. It only lights up when your cursor sits on a previously merged cell. Click it and the big cell splits back into the originals.
Quick warning that Excel itself shows: when you merge cells containing different values, only the top-left value survives. The rest is gone for good. If you’ve already merged and lost data, Ctrl+Z is your only rescue.
Where is the merge cells option in Excel if the icon isn’t there?
Sometimes the ribbon has been customized—by you, by IT, or by a corporate template—and the Alignment group looks bare. Right-click anywhere on the ribbon, choose Customize the Ribbon, and reset it to default. That brings the merge cells option in Excel right back where it belongs.
There’s a second route that always works, even on a locked-down machine. Select your range, right-click, choose Format Cells, go to the Alignment tab, and tick the Merge cells checkbox. It’s slower, but it’s the classic dialog box and it never disappears. Some old-school accountants still use it because it feels more deliberate.
A third shortcut: Alt + H + M + C merges and centers, Alt + H + M + M merges without centering, Alt + H + M + A merges across, and Alt + H + M + U unmerges. Learn those four and you’ll never hunt through menus again.
What the merge cells icon in Excel actually means
The icon—several small cells becoming one with an «a» centered inside—isn’t decoration. The melting squares show the merge, and the «a» represents centered text. Microsoft has kept this visual across light and dark themes and across Windows and Mac because consistency matters when you switch machines.
One habit worth building: after merging, check your row height and column width. Merging doesn’t resize anything automatically, so your new big cell may look cramped. Drag the row border or double-click it to auto-fit. This trips up almost every first-time user.
Should you merge cells at all? A blunt opinion
If your sheet is a final report or a printed calendar, merge away. It’s clean and it works. But if you plan to sort, filter, run pivot tables, or paste data into that area later, merging cells will break your workflow. Excel can’t sort a range with merged cells, and filters behave unpredictably.
The professional alternative is Center Across Selection. It’s buried in Format Cells > Alignment > Horizontal, and it visually centers text across several cells without actually merging them. Your data stays intact, sorting still works, and pivot tables don’t choke. I’d argue this should be the default for anyone building living spreadsheets.
So yes, know where the merge cells button in Excel is—Home, Alignment, second icon row. But also know when to skip it. That distinction is what separates someone who formats a sheet from someone who maintains one.
FAQ: common questions about merging cells in Excel
- Where is merge cells in Excel on a Mac? Same place: Home tab, Alignment group, dropdown arrow next to the merge icon.
- Why is my Merge Cells button greyed out? Usually because you’re editing a cell, you’re inside a table with a filter active, or the sheet is protected. Press Enter to exit edit mode or unprotect the sheet.
- Can I merge cells without losing data? Not directly. Concatenate the values first with a formula like =A1&» «&B1, paste the result as text, then merge.
- Does merging cells affect formulas? Yes. Formulas referencing a merged range only read the top-left cell. Plan your references before merging.
That’s the whole map. Home tab, Alignment group, dropdown arrow, four options, four shortcuts. Stop scrolling forums and start merging—or better, stop merging and try Center Across Selection. Your future self, the one running pivot tables, will thank you.