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.
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. The same idea underpins a lot of everyday Excel work, so the few minutes spent getting it right here pay back across every sheet you build afterwards. Treat it as a pattern, not a one-off, and it stops being something you look up and starts being something you reach for. The difference between a quick fix and a sheet you can trust is the extra minute you spend validating “merge cells in excel and keep all data”. Start on a copy or a tiny sample, keep the affected cells visible, and compare the result with the tool above 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. One habit worth forming early: name the cells that hold your inputs, so the formula reads in plain language instead of a string of cell addresses. A reviewer — or you in three months — can then follow the logic without decoding what B7 and D2 were supposed to mean, which is most of what makes a sheet maintainable.
In Google Sheets
If you are in Google Sheets rather than Excel, the good news is that the formula shown here is identical and the workflow barely changes — menus sit across the top instead of in a ribbon, and a few function names differ slightly, but anything you build here moves across with little or no rework. Nothing on this page is behind a login: the tool runs entirely in your browser, the formula is shown in full with one-click copy, and the steps work the same on Windows and Mac. That is the whole promise here — the exact answer, a way to prove it on your own numbers, and just enough context to make it stick. If you take one thing from this page on “merge cells in excel and keep all data”, make it the habit rather than the keystrokes: set the problem up with labelled inputs, reference those cells, and let Excel do the recomputing. Bookmark the page for the syntax, but do the example once in a blank sheet and check it against the tool above — five minutes of hands-on practice fixes the method in memory far better than re-reading, and it surfaces the small snags while they are still harmless. After that the technique is genuinely yours: faster than searching for it again, and reliable enough to drop into work that other people depend on.
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
This is also commonly searched as “excel merge cells keep all text”, “excel merge cells and keep all text” and “how to merge cells in excel keeping all data”. They describe the identical operation, so you are in the right place no matter how you phrased it.
Why do people search for this in so many different ways?
Because the same task has many names. “excel merge cells keep all text”, “excel merge cells and keep all text”, “how to merge cells in excel keeping all data” all point at the one operation explained on this page, which is why they all lead here.