Merge and Center combines two things at once
Merge and Center takes multiple cells and turns them into one cell, then centers the text inside it. You use it when you want a title or heading to stretch across several columns instead of sitting in a single narrow box. The button does both actions together — it merges the cells and centers the content in one click.
This is different from straightforward centering text within existing cells. When you merge, you are actually combining the cells themselves. The cells to the right disappear, and their content is deleted unless you copy it first. Excel will warn you about this before it happens.
Key Takeaways
- Select the cells you want to merge before you click the Merge and Center button, which sits in the Alignment group on the Home tab.
- Merging deletes any content in the cells to the right, so copy that data elsewhere first if you need to keep it.
- You can merge cells without centering by using the dropdown arrow next to Merge and Center and choosing "Merge Cells" instead.
- To unmerge cells later, select the merged cell, click the Merge and Center dropdown, and choose "Unmerge Cells".
How to select cells before merging
Click on the first cell you want to include in the merge. Then hold Shift and click on the last cell. This selects all the cells in between. If the cells are not in a straight line, hold Ctrl instead of Shift and click each cell individually, but Merge and Center works best with cells in a single row or column.
For example, if you want a title to stretch across columns A through E in row 1, click cell A1, then hold Shift and click cell E1. You will see all five cells highlighted in blue. Now you are ready to merge.
Finding and clicking the Merge and Center button
Open the Home tab at the top of the ribbon. Look for the Alignment group — it is usually in the middle-right area of the ribbon. Inside that group, you will see a button that looks like a grid with lines converging toward the center. That is Merge and Center.
Click it once. Excel will merge your selected cells and center the text. If any of the cells to the right contained data, a dialog box will appear asking if you want to keep the content from the first cell only. Click OK to proceed.
What happens to data when you merge
When you merge cells, Excel keeps only the content from the top-left cell in your selection. Any text or numbers in the other cells are deleted. If you have important data in those cells, copy it to another location first.
For example, if you select cells A1 (containing "Sales Report"), B1 (containing "2024"), and C1 (containing "Final"), and then merge them, only "Sales Report" will remain. The words "2024" and "Final" will be gone. To keep all three pieces of information, you would need to combine them into one cell before merging, or put them in separate rows.
Merging without centering, if you prefer left or right alignment
The Merge and Center button does both actions at once, but you can separate them if you want. Click the small dropdown arrow next to the Merge and Center button. A menu appears with three options: Merge and Center, Merge Cells, and Unmerge Cells.
Choose "Merge Cells" if you want to merge without centering. The cells will combine, but the text will stay left-aligned (or whatever alignment was in the original cell). After merging, you can then use the alignment buttons elsewhere in the Alignment group to center, left-align, or right-align the text however you want.
Unmerging cells to separate them again
Click on the merged cell you want to separate. Then click the dropdown arrow next to Merge and Center and choose "Unmerge Cells". The merged cell splits back into its original separate cells. The text stays in the top-left cell, and the other cells become empty.
Unmerging does not restore data that was deleted during the original merge. If you deleted content from cells B1 and C1 when you first merged, unmerging will not bring that content back. You would need to type it in again or undo the merge when ready after it happens (using Ctrl+Z) to recover the lost data.
Common reasons to use Merge and Center
Merge and Center is most useful for creating titles and headers that span multiple columns. A spreadsheet with "Q1 Sales by Region" stretched across columns A through D looks more polished than the same text crammed into column A alone. It also makes the spreadsheet easier to read at a glance.
You might also use it to create section breaks in a large spreadsheet, or to format a cover sheet that sits above your actual data. Some people use it for labels in complex tables, though this can sometimes cause problems with sorting and filtering, so be cautious if your spreadsheet contains formulas or data you plan to reorganize later.
Frequently Asked Questions
Can I merge cells in a column instead of a row?
Yes. Select the cells in the column the same way — click the top cell, hold Shift, and click the bottom cell. Then click Merge and Center. The cells combine vertically, and the text centers within the merged area. This works for any rectangular selection of cells.
What if I merge cells and then realize I need the data I deleted?
If you merged just a moment ago, press Ctrl+Z to undo the merge. This restores the separate cells and brings back any content that was deleted. If you have already done other work since the merge, undo may revert those changes too, so use it carefully.
Does merging cells affect formulas or sorting?
Merged cells can cause problems with sorting and filtering. If you have a spreadsheet with data you plan to sort or filter, avoid merging cells within the data range. Merge cells only in header rows or title areas above your actual data table.
Can I merge cells that are not touching each other?
No. Merge and Center only works on cells that form a single rectangular block. You cannot select A1, C1, and E1 and merge them together. You can only merge cells that are adjacent and form a rectangle when selected.