How to Merge and Unmerge Cells in Google Sheets


Working in a spreadsheet

Want to merge cells collectively in Google Sheets? The course of is easy, however you’ll want to watch out not to lose some information. Here’s how to do it safely.

Merging cells in Google Sheets is an efficient approach to mix information from a number of cells in a spreadsheet. You can merge cells throughout rows or columns, however you’ll want to watch out to do it in a approach that doesn’t lose your information.

If you don’t understand how to merge cells in Google Sheets, you’ll be able to observe the steps outlined beneath.

Before Merging Cells in Google Sheets

Before you begin merging your information in Google Sheets, you want to pay attention to one of many largest limitations. When you merge cells in Google Sheets, solely the information from the highest cell is saved. The remainder of the information is misplaced and can’t be retrieved with out undoing the change.

If you’re making an attempt to merge information from a number of cells, you’ll be able to’t use the default cell merging device. Instead, you’d want to use a CONCATENATE operate to merge the information

How to Merge Cells in Google Sheets

You can simply merge your cells in Google Sheets utilizing both the format menu or the toolbar.

To merge cells in Google Sheets from the format menu:

  1. Open your Google Sheets spreadsheet.
  2. Select the cells you need to merge utilizing your mouse.
  3. From the menu, choose Format > Merge Cells.
  4. Select both Merge all, Merge vertically, or Merge horizontally.
    Options for merging cells in Google Sheets

To merge cells in Google Sheets from the toolbar:

  1. Open your Google Sheets spreadsheet.
  2. Select your cells.
  3. Press the Merge Cells icon to merge all cells or press the downwards arrow icon subsequent to it.
  4. If you press the downwards arrow, choose Merge vertically or Merge horizontally, relying in your desire.
    Merging cells in Google Sheets via the toolbar

Once you’ve merged the cells collectively, the cell measurement will seem greater and take the mixed place of the earlier cells. Example of merged cells in Google Sheets

How to Unmerge Cells in Google Sheets

If you’ve merged cells in Google Sheets, you’ll be able to simply unmerge them afterward. You received’t find a way to retrieve any misplaced information, however you’ll be able to restore the person cells to use once more.

To unmerge cells in Google Sheets:

  1. Open your Google Sheets spreadsheet.
  2. Select the merged cell.
  3. Press the Merge Cells button on the toolbar.
  4. Alternatively, press Format > Merge cells > Unmerge.
    Unmerging cells in Google Sheets

How to Merge Data from Cells in Google Sheets

You can’t merge cells in Google Sheets with out dropping information from a number of the cells—the information from one cell replaces the remaining. If you need to merge information from a number of cells, you’ll be able to both do it manually or use a operate like CONCATENATE to merge the information collectively in a brand new cell.

CONCATENATE works by merging the information from cells collectively and turning them right into a mixed textual content string. It doesn’t mix numbers by including them—it is going to merely place them collectively. For instance, if B1 contained the worth 1 and B2 contained the worth 2, a CONCATENATE method that mixed these cell values would return the consequence 12 and not 3.Example of a simple CONCATENATE formula in Google Sheets

For non-numerical values, CONCATENATE works the identical approach. If B1 contained a phrase (one) and B2 contained one other phrase (two), CONCATENATE will return the phrases collectively (onetwo). You would want to format the unique cells to guarantee there are areas or use ampersands (&) with empty textual content strings () to add a space.
An example CONCATENATE formula in Google Sheets using empty text strings

To use CONCATENATE to merge data from cells in Google Sheets:

  1. Open your Google Sheets spreadsheet.
  2. Select a new cell, then select the formula bar.
  3. To use CONCATENATE, type =CONCATENATE( in the formula bar and add cell values or a cell range. Eg. =CONCATENATE(A2,B2).
    An example of a simple CONCATENATE formula in Google Sheets
  4. If you want to add spaces between the cells, use an ampersand with an empty text string. Eg. =CONCATENATE(A3&” “&B3).
    An example of a CONCATENATE formula in Google Sheets using empty text strings

Making Changes in Google Sheets

Using our information above, try to be in a position to shortly merge or unmerge cells in Google Sheets. This is only one approach you may make adjustments to your Google Sheets spreadsheet, permitting you to manipulate and analyze your information in other ways.

If you need to hold monitor of the adjustments you’ve made, you’ll be able to view the edit historical past for a cell. If you need to attempt and make your spreadsheet extra colourful, you possibly can take into consideration including conditional formatting.