How to merge cells in Google Sheets

Updated: 07/06/2021 by Computer Hope
Google Sheets

There are two ways to merge cells in Google Sheets. To learn how to do so, select a link below and follow the steps.

Merge two or more cells using the Merge cells feature

In Google Sheets, you can merge two or more cells using the "Merge cells" feature.

  1. Access the Google Sheets website and open a new or existing spreadsheet.
  2. Highlight two or more adjacent cells you want to merge. For example, highlight cells A1 and B1 or C1 and C2.
  1. Click the Merge cells option in the formatting bar.

Merge cells option in Google Sheets

Note

When cells with multiple values are merged, the upper-right most cell becomes the data of the merged cell.

Merge two or more cells using a formula

In Google Sheets, you can merge two or more cells using a formula. Utilizing an ampersand (&) in a formula acts to combine the values in cells together.

Merge Cells using a formula in Google Sheets

In this example, the formula =A1&B1 combines the values in cells A1 and B1 to cell C1. In this same example, to add a space between the two cell values, include a "space" in it (e.g., =A1&" "&B1). You would use double quotes around a space to add a space in the formula and the resulting merged value.

To combine more than two cells, add each cell to the formula, using an ampersand (&) between each cell reference. For example, to combine cells A1, B1, C1, and D1, use the formula =A1&B1&C1&D1.