In Excel: select the cells, then Home ▸ Merge & Center (Alt H M C on Windows). To avoid the data-loss trap, prefer “Center Across Selection” instead.
On this page8
Select the cells you want to merge.
On the Home tab, click the arrow next to Merge & Center and choose the merge type.
To unmerge later, select the merged cell and click Merge & Center again to toggle it off.
Prefer Format Cells ▸ Alignment ▸ Center Across Selection when you only need centred text.
Merge cells or combine their text?
Start with Ada in A2 and Lovelace in B2 on a spare sheet. Choose the operation by the result you need.
A2| Operation | Result | Original values |
|---|---|---|
| Merge & Center on A2:B2 | One merged cell containing Ada | B2 is discarded after confirmation |
| =A2&" "&B2 in C2 | Ada Lovelace in C2 | A2 and B2 stay intact |
| Unmerge after merging | Ada in A2; B2 empty | Discarded text does not return |
If columns are cut off, scroll the table sideways.
- For a title across A1:D1, put the title in A1 and leave B1:D1 empty before merging.
- If Merge & Center is disabled, finish editing the cell and check whether the selection is inside an Excel table.
- To retain both names, combine them in a new cell instead. Unmerge restores cell boundaries, not deleted contents; use Undo immediately after an unwanted merge.
Documentation reviewed .
Microsoft: Merge and unmerge cellsMicrosoft: Combine text from cells
What this does
Merging joins two or more cells into one larger cell, usually to centre a title across columns. It is a visual tool, not a data one: a merged block keeps only the top-left value and discards the rest, and it breaks sorting, filtering and many formulas. That is why experienced users reach for “Center Across Selection” when they only want the look without the side effects. Before you run it on a workbook other people depend on, try it on a copy or a few rows first. Undo only reaches back through the current session, so a quick trial run is the cheapest way to see exactly what will change before the file is saved and shared. The difference between a quick fix and a sheet you can trust is the extra minute you spend validating “merge cells in excel”. Start on a copy or a tiny sample, keep the affected cells visible, and compare the result with the outcome you expected before you touch the real workbook. When this is a ribbon command, the selection matters more than the button: confirm the range, apply the command, then spot-check the output before saving. The point is a layout choice that keeps the sheet readable and sortable, but the practical win is that someone else can open the file and understand what happened without asking you.
A worked example
To centre a report title over columns A to D, select A1:D1 and click Merge & Center on the Home tab. The text sits centred across the four columns. But if A1:D1 had four values, only A1 survives. The safe alternative: select the range, open Format Cells ▸ Alignment ▸ Horizontal ▸ Center Across Selection — same look, no merge, no lost data. Merging makes headers and titles look polished, but used inside a data range it quietly sabotages sorting, filtering and formulas. Knowing the safe alternative keeps your sheet both tidy and functional. If this is something you do often, add the command to the Quick Access Toolbar (right-click it on the ribbon and choose Add to Quick Access Toolbar) or learn its shortcut, so next time it is one click instead of a hunt through the menus.
In Google Sheets
This is a command rather than a formula, so there is no syntax to carry over. Google Sheets arranges its commands in menus across the top instead of a ribbon, names some of them differently and does not have every Excel command — look for the equivalent in the Sheets menus or its help before assuming the steps match. The aim was to get you unstuck fast and leave you a little more capable than a copy-paste would. The answer is at the top and the detail above shows why it holds — so the next time a colleague asks, you can answer without reaching for search. The short version of “merge cells in excel”: the answer is at the top of this page, and the sections above explain why each step matters, so a variation of the problem does not stump you. Try it once on a copy of a real file and the steps stick far better than re-reading them.
Common mistakes
- Confirming a merge of populated cells: only the top-left value survives in a left-to-right sheet. Unmerge does not restore discarded contents.
- Merging inside a table you later sort or filter, which Excel will refuse or break.
- Using merged cells where a formula needs to reference each one individually.
- Forgetting that merged cells complicate copy-paste and keyboard navigation.
Frequently asked questions
Why is Merge & Center greyed out?
Finish editing the cell and check whether the selection is inside an Excel table. Microsoft documents both as reasons the command can be disabled.
Why is sorting greyed out after merging?
Sorting and filtering cannot reorder rows that span a merged block. Unmerge the cells, or use Center Across Selection, to restore those features.
How do I merge without losing data?
You cannot keep all values in a true merge. Combine them first with =A1&" "&B1, or use Center Across Selection for the visual effect only.
Does Google Sheets merge the same way?
Yes — Format ▸ Merge cells offers the same options, with the same caveat that only the top-left value is kept.
Other ways people ask this
People reach this page typing “excel merge cells”, “how do i merge cells in excel”, “how to merge cells excel” and “how to merge cell in excel”, among other phrasings; whichever wording you used, the fix above is the one you want.
Why do people search for this in so many different ways?
Because the same task has many names. “excel merge cells”, “how do i merge cells in excel”, “how to merge cells excel” all point at the one operation explained on this page, which is why they all lead here.