How to Join Cells in Google Sheets: Merge or Combine

To join cells in Google Sheets by merging them, select the adjacent cells, then choose Format > Merge cells and pick a merge option. If you mean joining the text from several cells while keeping each cell intact, use a formula instead. These are different actions: merging can discard values in cells other than the upper-left one, so check the selection before you proceed.

What You’ll Need

A Google Sheets spreadsheet open in a web browser, with permission to edit it.
A clear idea of whether you want one larger cell for layout or want to combine text without removing the original values.
If you are merging cells, a copy of any data you cannot afford to lose. Copy it elsewhere first if the selected cells contain more than one value.

Step-by-Step

Open the sheet and locate the cells. Click the spreadsheet you want to edit. Find the cells you want to join and check their contents. For a visual heading, the cells are often in the same row, such as A1 through D1. For a large label over a block, they may cover multiple rows and columns. Merging works on a single adjacent rectangular selection; it does not join scattered cells.
Select the full range. Click the first cell, then drag across the neighboring cells you want to include. You can also click the first cell, hold Shift, and click the last cell in the range. The highlighted outline should cover exactly the intended rectangle. If you select a whole row or column by clicking its heading, Sheets may select much more than you need, so use the cell grid for a precise selection.
Check which values will remain. When a range is merged, Sheets keeps the content in the upper-left cell and discards the contents of the other selected cells. For example, merging A1:D1 keeps A1’s value; it does not join A1, B1, C1, and D1 into a sentence. If there is important content elsewhere in the selection, copy it to another location or use a text-combining formula described below. This check prevents the most common form of data loss.
Open the merge commands. With the range still selected, click Format in the top menu, point to Merge cells, and review the choices. Google Sheets may also show a merge-cells button in the toolbar, but the Format menu is the clearest route because it names each option. If the menu item is unavailable, see Troubleshooting before changing the sheet.
Choose the right merge type. Choose Merge all to turn the entire selected rectangle into one cell. Choose Merge horizontally to merge cells across each selected row separately, or Merge vertically to merge cells down each selected column separately. For example, selecting A1:C3 and choosing Merge horizontally creates one merged cell in each of the three rows. Selecting that same range and choosing Merge all creates one cell spanning all nine cells.
Review the result and format it. Confirm that the merged cell displays the value you intended to keep and that the surrounding layout still makes sense. Use the toolbar to set horizontal or vertical alignment, text wrapping, font, fill color, or borders as needed. A long heading may need wrapping or a taller row. Formatting improves appearance, but it does not restore any values removed during merging.
Undo or unmerge if necessary. If you just merged the wrong range, click Edit > Undo or use Ctrl+Z on Windows or Chromebook. On a Mac, use Command+Z. If you want to split an existing merged cell, select it and choose Format > Merge cells > Unmerge. Unmerging restores the individual cell grid, but it does not bring back values that were discarded when the cells were merged.

To combine text without merging: Keep the original cells separate and put a formula in an empty cell. If A2 contains Ada, B2 contains Lovelace, and C2 is blank, enter =TEXTJOIN(" ", TRUE, A2:C2) in D2. The result is Ada Lovelace; the TRUE argument tells the function to ignore empty cells, and the space inside the quotation marks separates the words. You can replace the space with another separator, such as a comma and a space. The result is text in D2, not a merged cell. If you need a fixed result rather than a formula, copy the result and use Edit > Paste special > Values only in the destination. Google Sheets uses this menu path; Excel for Windows instead has its own Merge & Center command on the Home tab, so the interface instructions are not interchangeable.

Common Mistakes

Expecting a merge to combine the contents. Merging changes the cell layout; it does not concatenate words or numbers. If B2 says “North” and C2 says “Branch,” merging B2:C2 will not produce “North Branch.” Use a formula such as TEXTJOIN when you want both pieces of text retained in a combined result.

Merging before checking every cell. A range can look like a heading area even when some of its cells contain a note, number, or formula. Since only the upper-left value survives, inspect the selection and move anything important before merging. Do not assume that a warning or undo will be available later.

Selecting too much or choosing the wrong direction. Merge all, horizontal, and vertical do different things. A full-row selection can create an unexpectedly wide merge, and Merge all can collapse a multirow block into one cell when separate row headings were intended. Confirm the selected outline and choose the option that matches the layout.

Merging cells in a data table. A merged heading may look neat, but merged cells can interfere with sorting, filtering, filling formulas, and selecting a consistent table range. Keep cells unmerged in the main body of a dataset. If a title needs a wider appearance, consider putting it in one cell and adjusting column widths or alignment instead.

Tips

Use merging mainly for presentation, such as a report title above a small table. Keep labels and records in ordinary, unmerged cells wherever you may later sort, filter, calculate, or export the data. A tidy visual heading is not worth making the underlying table harder to use.

Plan the range before selecting it. For one heading across columns A to D, merge only those four cells in the heading row. If each row needs its own combined area, select the corresponding block and use Merge horizontally. Avoid selecting entire columns unless you truly want a merge across a very large range.

Consider alignment after merging. A heading often reads clearly when centered horizontally and vertically, but left alignment may be more useful for a long label. Turn on text wrapping when the content should remain visible inside the merged area. If the row height does not adjust as expected, increase it manually by dragging the row boundary.

If you need to preserve a joined-text result, leave the source cells untouched and put the formula in a separate column or sheet. This makes it easier to correct a source value later and lets the combined result update. If a report needs static text, paste the formula result as values only after checking it. Merging is not a substitute for either of these approaches.

Troubleshooting

Merge cells is grayed out or unavailable. First make sure you have selected at least two adjacent cells and that you have edit access. A viewer or commenter cannot change the layout, and protected cells may prevent editing. If the range is part of a protected sheet, ask the owner for permission or have them adjust the protection. Also check that your selection is a simple rectangle rather than disconnected ranges.

Sheets says it cannot merge the selection. The range may overlap an existing merged cell or include a complicated mix of merged and unmerged areas. Select the affected area and use Format > Merge cells > Unmerge where available, then select a clean rectangular range and try again. If the sheet contains existing merges you need to keep, work on a smaller range that does not overlap them.

Some text or numbers disappeared. Merging keeps the upper-left value and removes the other selected values. If the action just happened, use Undo immediately. If you have made more edits since then, inspect version history using File > Version history > See version history and restore or copy the needed content from an earlier version. Restoring a version can affect other edits, so review the changes and, if possible, copy the missing value back rather than replacing the whole current sheet.

The merged cell shows the wrong value or appears blank. Select the merged area and check the formula bar; the surviving value should come from its upper-left cell. If that cell was empty, the merged result may look blank even if other cells previously contained data. Undo if possible, or check version history. If the cell contains text that is clipped, widen the columns, increase the row height, or enable wrapping rather than merging additional cells.

The text formula returns an error or an unexpected result. Confirm that the formula is in an empty cell, that the referenced range is correct, and that the source cells contain the expected values. If your spreadsheet locale uses semicolons between function arguments, Sheets may require semicolons rather than commas. Also check that the separator inside the quotation marks is what you want; a space creates a readable gap, while an empty separator joins values directly.

Frequently Asked Questions

Can I join cells in Google Sheets without losing data?

Yes, if you mean combining their text rather than merging the cells. Use TEXTJOIN or another formula in a separate cell and leave the source values in place. A true merge keeps only the upper-left cell’s content, so copy other values somewhere safe first.

What is the difference between Merge all and Merge horizontally?

Merge all turns the selected rectangular range into one cell. Merge horizontally makes a separate merged cell for each selected row. Merge vertically makes a separate merged cell for each selected column. Check the selection and the resulting layout before choosing.

Can I merge cells that are not next to each other?

No. A merge applies to a single adjacent rectangular range. If the cells are separated, you can merge each suitable block individually, or use a formula to bring their text together in another cell.

How do I undo a merge in Google Sheets?

Use Format > Merge cells > Unmerge to return the merged area to separate cells. Ctrl+Z on Windows or Chromebook, or Command+Z on Mac, reverses a recent merge. Unmerging alone does not restore the discarded values.

Can I sort or filter a range that contains merged cells?

Merged cells can make sorting and filtering awkward or unavailable for parts of a range. For dependable data operations, keep the table itself unmerged and use merged cells only for decorative headings outside the records.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.