Merge and Center is in the Alignment group on the Home tab

Open any Excel spreadsheet and look at the ribbon — the toolbar across the top. Click the Home tab if it is not already selected. In the middle section of that ribbon, you will see a group labeled Alignment. Inside that group sits a button that shows overlapping boxes with the words "Merge & Center" underneath. That is the button you need.

The button's location does not change between Excel versions, though the exact appearance of the icon may shift slightly. If you are using Excel on a Mac, the Home tab and Alignment group are in the same place, just organized slightly differently on your screen.

Key Takeaways

  • Merge and Center lives in the Alignment group on the Home tab of the ribbon, not in a menu or separate dialog.
  • You must select the cells you want to merge before clicking the button — selecting happens first, then merging.
  • Merging combines multiple cells into one larger cell and centers the text automatically, but deletes the content of all cells except the first one.
  • If you only want to center text without merging, use the regular center alignment button next to Merge and Center instead.

How to select cells before merging

Merging only works after you have chosen which cells to combine. Click on the first cell you want to merge, then drag across to the last cell. If you want to merge cells A1 through D1 (a row), click A1 and drag right to D1. If you want to merge a block like A1 through D5, click A1 and drag down and to the right until you reach D5.

You can also click the first cell, hold Shift, and click the last cell in the range you want. This method works better if the cells are far apart on your screen. Once the cells are highlighted in blue, you are ready to click Merge and Center.

What happens when you merge cells

When you click Merge and Center, Excel combines all the selected cells into a single larger cell. The text from the first cell (the one you clicked first) stays in the merged cell and moves to the center. The content of every other cell in the selection disappears — Excel does not combine the text, it deletes it.

This is why people often lose data by accident. If you select cells A1 through D1 and A1 contains "Name" while B1 contains "Address", clicking Merge and Center will keep only "Name" and erase "Address". Before you merge, make sure the cells you are combining either contain only one piece of information or contain data you do not need to keep.

The difference between Merge and Center and regular center alignment

Merge and Center does two things at once: it merges the cells and centers the text. If you only want to center text without combining cells, use the regular Center button instead — it is the one with horizontal lines in the middle, located right next to Merge and Center in the Alignment group.

Centering text without merging is safer because it does not delete any data. You keep all your original cells and all their content; the text just moves to the middle. Use this method when you want a centered heading but need to preserve the cell structure underneath.

How to unmerge cells if you change your mind

Click on the merged cell to select it. Go back to the Home tab and find Merge and Center in the Alignment group. Click the small arrow next to it to open a menu. Select Unmerge Cells from the dropdown. The merged cell will split back into separate cells, and the text will stay in the first cell of the original range.

Unmerging does not restore the text that was deleted from the other cells — that data is gone. If you unmerge a cell that originally contained "Name" in A1 and "Address" in B1, you will get "Name" back in A1 and an empty B1. This is another reason to think carefully before merging.

When merging cells causes problems

Merged cells can break sorting, filtering, and formulas. If you have a spreadsheet where you sort data by column, merged cells in that column will not sort correctly — they stay in place while the rest of the data moves. Filters also behave unpredictably around merged cells.

If you are building a spreadsheet that other people will use or that you will add data to later, avoid merging cells in your data area. Use merging only for titles and headers at the very top, where sorting and filtering do not happen. For everything else, use regular center alignment or adjust column width instead.

Frequently Asked Questions

Can I merge cells that are not next to each other?

No. You can only merge cells that form a continuous rectangle — a row, a column, or a block. You cannot select A1 and C1 and merge them while skipping B1. If you need to combine non-adjacent cells, you will need to use a formula instead.

What if I merge cells and then realize I need the deleted text back?

The deleted text is gone permanently. Undo (Ctrl+Z or Command+Z) when ready after merging if you catch the mistake right away. If you have already saved the file, the text cannot be recovered. This is why it is important to check what each cell contains before you merge.

Does merging cells change how my spreadsheet prints?

Yes. Merged cells print as a single larger cell, which can affect how your data looks on the page. If you are printing a spreadsheet with merged cells, preview it first to make sure the layout looks the way you want.

Why does my merged cell look different on someone else's computer?

Merged cells can display differently depending on screen size, zoom level, and font settings. What looks centered on your monitor might wrap differently on another person's screen. For important documents, test how merged cells look at different zoom levels before sharing.