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 page7
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.
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. For “merge and center in excel”, the reliable version is a short checking loop, not just the first command that appears to work. Run it on a deliberately small range first, watch how the affected cells change, and only then apply the same setup to the full sheet. 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. That is what makes a workspace setting that makes a big sheet comfortable to navigate useful in real work: repeatable, auditable, and not dependent on memory or luck.
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. When the result is not what you expected, undo straight away rather than repairing it by hand — undo restores the sheet exactly, while manual fixes tend to leave small inconsistencies behind that surface later.
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. Nothing on this page is behind a login or a download: the exact answer is at the top, and the detail below it is there for when you need it. That is the whole promise here — the answer first, and just enough context to make it stick. If you take one thing from this page on “merge and center in excel”, make it the order of checks rather than the individual clicks: confirm what is selected, apply the step, and look at the result before moving on. That small routine is what keeps Excel work predictable when the same task comes back in a slightly different workbook.
Common mistakes
- Merging cells that hold data — everything except the top-left value is silently deleted.
- 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 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
On the way here you may have searched this as “merge and center excel”, “how do i merge and center in excel”, “how do you merge and center in excel” and “where is merge and center in excel” — it is all the same task, and this page is the single, complete answer to it.
Why do people search for this in so many different ways?
Because the same task has many names. “merge and center excel”, “how do i merge and center in excel”, “how do you merge and center in excel” all point at the one operation explained on this page, which is why they all lead here.