What joining cells does and when you need it
Joining cells in Excel means combining two or more adjacent cells into a single larger cell. When you join cells, the content from the leftmost cell stays, and any text in the cells to the right disappears. The merged cell stretches across the space where the original cells were.
You typically join cells to create a title that spans multiple columns, to group related information visually, or to make a spreadsheet easier to read. For example, you might join cells A1 through D1 to center a report title across the top of your data, or join cells in a header row to label a section that covers several columns below it.
Joining cells changes how Excel treats the space — it becomes one cell instead of many, which affects how formulas reference it and how data moves when you sort or filter. Understanding this before you join is important, because undoing a join sometimes requires rebuilding what was there.
Key Takeaways
- Select the cells you want to join by clicking the first cell and dragging to the last one, or by holding Shift and clicking the last cell.
- Open the Merge & Center button in the Home tab (or use Format menu) and choose whether to merge and center, merge across, or merge cells without centering.
- Joined cells keep only the content from the top-left cell; text in other cells is deleted when you merge, so copy it elsewhere first if you need it.
- Joined cells act as a single cell in formulas and sorting, which can cause problems if your data needs to move or be referenced by row — avoid joining in data tables.
Selecting the cells you want to join
Start by clicking the first cell you want to join. This is usually the top-left cell of the range. Hold down your mouse button and drag to the last cell you want to include, or release the mouse and then hold Shift while clicking the last cell. Both methods select all cells in between.
You can join cells horizontally (across columns in the same row), vertically (down rows in the same column), or in a rectangle (multiple rows and columns at once). Excel lets you join any rectangular block of cells. If you try to select cells that are not touching or not in a rectangle shape, the merge will not work.
After you have selected the cells, look at the cell reference box at the top left of the screen — it shows the range you selected, like "A1:D1" or "B2:B10". This confirms you have the right cells before you merge.
Using the Merge & Center button in the Home tab
With your cells selected, look at the Home tab in the ribbon at the top of Excel. Find the button labeled "Merge & Center" — it usually shows a small grid icon. Click the small arrow next to it to see your options.
You have three choices: Merge & Center combines the cells and centers the text horizontally and vertically. Merge Across combines the cells but does not center the text — it stays left-aligned. Merge Cells combines them without any centering. Choose the one that matches what you want the final result to look like.
After you click, the cells join into one. If you selected cells with text in more than one of them, Excel shows a warning that it will delete the content in all but the first cell. Click OK to proceed, or click Cancel if you need to copy that text somewhere else first.
Using the Format menu if Merge & Center is not visible
If you cannot find the Merge & Center button in your Home tab, or if you are using an older version of Excel, use the Format menu instead. With your cells still selected, click Format in the menu bar at the top.
Look for an option called "Merge Cells" or "Merge & Center" — the exact wording depends on your Excel version. Click it, and a small menu appears with the same three options: Merge & Center, Merge Across, and Merge Cells. Choose the one you want.
The result is the same as using the ribbon button. The cells join, and the content from the leftmost cell remains while the others are cleared.
What happens to the text when you join cells
When you join cells that contain text, only the text from the top-left cell survives. If cell A1 says "Sales Report" and cell B1 says "2024", joining them keeps "Sales Report" and deletes "2024". Excel warns you before this happens, but the warning appears only once, even if you are joining a large range.
If you need to keep text from multiple cells, copy it to a safe location first — paste it into a cell below your data, or into a text document — before you join. Then you can refer back to it if you need the information later.
After cells are joined, you can edit the text in the merged cell the same way you would edit any other cell: double-click it or press F2 to enter edit mode, make your changes, and press Enter.
Why you should avoid joining cells in data tables
Joined cells cause problems when your spreadsheet contains actual data that you sort, filter, or reference with formulas. When cells are merged, Excel treats them as a single cell, which breaks the row-and-column structure that sorting and filtering depend on.
For example, if you have a table of sales data and you join cells in one of the columns, sorting that table may not work correctly because Excel cannot move a merged cell the same way it moves regular cells. Formulas that reference a merged cell sometimes behave unexpectedly, especially if the formula is in a different row.
The safe rule: join cells only in header rows, titles, or labels — places where the content does not need to move or be sorted. Keep your actual data in unmerged cells so Excel can work with it normally.
How to unmerge cells if you change your mind
To undo a merge, click anywhere in the merged cell to select it. Then go to the Home tab and click the Merge & Center button again (or use Format menu). This time, instead of merge options, you see "Unmerge Cells" — click it.
The merged cell splits back into its original separate cells. The text that was in the merged cell stays in the top-left cell, and the other cells become empty. If you had text in those other cells before the merge, it was deleted and does not come back — this is why copying important text before you merge is worth the extra step.
Frequently Asked Questions
Can I join cells that are not next to each other?
No. Excel only joins cells that form a rectangle — they must be touching and arranged in rows and columns with no gaps. If you select cells that are separated or scattered, the merge button will not work.
What happens to a formula if I join the cells it references?
If a formula refers to a merged cell, it usually still works, but it references only the top-left cell of the merged range. If you merge cells that a formula depends on, test the formula afterward to make sure it still calculates correctly.
Can I join cells in Excel on a phone or tablet?
The mobile version of Excel has limited merge options. You can usually find merge in the Format menu, but the full range of choices may not be available. For complex merging, use the desktop version of Excel.
Does joining cells change the data in my spreadsheet?
Joining cells deletes the content of all but the top-left cell, so yes, it changes what is there. It does not change the data in other parts of your spreadsheet, only in the cells you merge.
Why does my merged cell look misaligned after I join it?
If you used "Merge Cells" instead of "Merge & Center", the text stays left-aligned by default. Click the merged cell and use the alignment buttons in the Home tab to center it or move it to the right if that is what you want.