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. Keep the inputs visible and clearly labelled and the whole thing stays auditable — anyone who opens the file later, including you, can see at a glance exactly what feeds the result and change one assumption without hunting through the formula. Treat “merge two cells in excel without losing data” as a small repeatable workflow rather than a one-off click you hope to remember next time. Use a small test block before the live file, so any surprise in the affected cells shows up while it is still harmless. 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 turns a layout choice that keeps the sheet readable and sortable into a method you can reuse, explain, and defend when the workbook leaves your screen.
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
Everything above works in Google Sheets too. Excel and Sheets share the formula syntax used here; only the surrounding menus are arranged differently. That portability is deliberate — learn it once and it follows you between the two tools and across Windows and Mac. 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, the tool proves it, and the detail above shows why it holds — so the next time a colleague asks, you can answer without reaching for search. Here is the takeaway for “merge two cells in excel without losing data”: copy the answer if you are busy, but if you have a spare few minutes, rebuild the example in Excel yourself with the tool above open beside it. That single pass — type it, run it, watch the result move when you change an input — is what turns a formula you found into a technique you trust. Keep your inputs labelled and referenced, never hard-coded, and the same sheet stays correct and auditable as it grows. Done that way, you will not need to look this up again, and you will be the person others ask.
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.