Get Access to World’s largest Template Library & Tools

How to Merge / Combine Cells in Google Sheets

Merging and combining cells can help you manage your content easily. Read on the following steps to find out how to get it done in Google Sheets.

How to Merge / Combine Cells in Google Sheets

  • Step 1: Merge or Combine Spreadsheet Cells in Google Sheets Using the Format Menu

    how to merge combine cells in google sheets step

    To merge or combine cells in a Document Google Sheet, you can use the Format menu. First, select at least two adjacent cells by either clicking and dragging across your selection or clicking them while holding down the Ctrl key. Next, open the Format menu in the menu bar before selecting one of the options under Merge Cells.

  • Step 2: Merge or Combine Your Sheet Cells Using the Merge Cells Shortcut

    how to merge combine cells in google sheets step

    When merging cells in a Report Google Sheet, you can also use the shortcut in the menu bar. Highlight the desired cells by clicking and dragging or clicking with Ctrl, then click the Merge Cells button (to the right of the Borders menu) in the menu bar. Alternatively, click the Select Merge Type option (downward arrow) and choose from the options in the dropdown list.

  • Step 3: Merge or Combine Multiple Rows in Google Sheets

    how to merge combine cells in google sheets step

    When merging or combining multiple rows, start by clicking and dragging across the desired cells or clicking the cells while holding Ctrl. Open the Format menu, go to Merge Cells, and select Merge Horizontally from the dropdown list. If you prefer, pick one of the Select Merge Type options next to the Merge Cells shortcut.

  • Step 4: Merge or Combine Multiple Columns In Google Sheets

    how to merge combine cells in google sheets step

    Select or highlight the target cells if you need to merge or combine more than one column at once. After selecting your desired cells, open the Format menu or use the Merge Cells shortcut (in the menu bar) and select the Merge Vertically option.

  • Step 5: Merge or Combine Multiple Rows or Columns in Google Sheets

    how to merge combine cells in google sheets step

    To select a whole row or column for merging, you can simply click on the respective header of your target row or column. Once you highlight the entire row or column, select your desired merging option in the Format menu or Merge Cells shortcut. Additionally, click and drag or hold Ctrl and click to select more than one row or column header at once.

Can I still select cells individually after merging or combining them?

No, you cannot select previous cells after combining them. After merging or combining multiple cells, they are now considered a larger singular cell in the spreadsheet.

Can I merge or combine cell groups that are not adjacent to each other?

No, it is not possible to merge or combine cells this way. To merge cells, they must be next to each other.

Can I merge or combine cell groups selected in any highlight pattern?

No, you cannot merge or combine cells highlighted in all patterns. You can only merge cells when selecting them in a box or line pattern.

How do I unmerge combined cells from each other?

Yes, you can unmerge combined cells. To unmerge, select the combined cell before opening the Format menu and selecting the Unmerge option under the Merge Cells list.

What happens if I copy and paste text from a merged cell to a non-merged cell?

Copying and pasting text from a merged cell will create a new merged cell with the size.

More in Google

How to Outline Cells in Google SheetsHow to Print Selected Cells in Google Sheets
How to Make an Organizational Chart in Google SheetsHow to Dedupe in Google Sheets
How to Organize by Date in Google SheetsHow to Open Excel in Google Sheets
How to Subtract in Google SheetsHow to Make an Org Chart in Google Sheets
How to Subtract Cells in Google SheetsHow to Make a Table in Google Sheets
How to Sort by Number in Google SheetsHow to Sort by Multiple Columns in Google Sheets
How to Start a New Line in Google SheetsHow to Split a Column in Google Sheets
How to Split Names in Google SheetsHow to Split First and Last Names in Google Sheets
How to Sort Rows in Google SheetsHow to Sort by Last Name in Google Sheets
How to Split Columns in Google SheetsHow to Split Cells in Google Sheets
How to Spell Check in Google SheetsHow to Sort by Due Date in Google Sheets
How to Sort in Google SheetsHow to Pin a Column in Google Sheets
How to Pin Rows in Google SheetsHow to Sort by Column in Google Sheets
How to Sort Numbers in Google SheetsHow to Sort Data in Google Sheets
How to Sort Multiple Columns in Google SheetsHow to Sort Columns in Google Sheets
How to Sort by Date in Google SheetsHow to Sort Alphabetically in Google Sheets
How to Sort Dates in Google SheetsHow to Skip a Line in Google Sheets
How to Show Formulas in Google SheetsHow to Search on Google Sheets
How to Search in Google SheetsHow to Rename Columns in Google Sheets
How to Remove Underline in Google SheetsHow to Remove Lines in Google Sheets
How to Set Print Area in Google SheetsHow to Separate First and Last Name in Google Sheets
How to Sort by Color in Google SheetsHow to Sort a Column in Google Sheets
How to Select Multiple Rows in Google SheetsHow to Select Multiple Cells in Google Sheets
How to Remove Gridlines in Google SheetsHow to Select a Data Range in Google Sheets
How to Round Numbers in Google SheetsHow to Save in Google Sheets
How to Resize Rows in Google SheetsHow to Remove Empty Rows in Google Sheets
How to Save Google SheetsHow to Resize Columns in Google Sheets
How to Remove Duplicates in Google SheetsHow to Rename a Column in Google Sheets
How to Refresh a Pivot Table in Google SheetsHow to Reference Another Sheet in Google Sheets
How to Put Checkboxes in Google SheetsHow to Remove Blank Rows in Google Sheets
How to Protect Cells in Google SheetsHow to Merge and Center Cells in Google Sheets
How to Merge Two Columns in Google SheetsHow to Merge Two Cells in Google Sheets
How to Resize Cells in Google SheetsHow to Make a New Line in Google Sheets
How to Name Columns in Google SheetsHow to Make a Line Chart in Google Sheets
How to Multiply in Google SheetsHow to Make a Header in Google Sheets
How to Multiply Two Cells in Google SheetsHow to Merge Columns in Google Sheets
How to Merge Cells in Google SheetsHow to Make an XY Graph in Google Sheets
How to Make a Graph on Google SheetsHow to Make a Column Stay in Google Sheets
How to Open Excel Files in Google SheetsHow to Name a Column in Google Sheets
How to Multiply Columns in Google SheetsHow to Multiply Cells in Google Sheets
How to Move a Column in Google SheetsHow to Move Rows in Google Sheets
How to Make a Checkmark in Google SheetsHow to Make a Bar Chart in Google Sheets
How to Make Text Wrap in Google SheetsHow to Make a Cell Bigger in Google Sheets
How to Make a Budget in Google SheetsHow to Move Columns in Google Sheets
How to Move Cells in Google SheetsHow to Make Text Fit in Google Sheets
How to Format Cell Size in Google SheetsHow to Make a Box Bigger in Google Sheets
How to Make Line Graphs in Google SheetsHow to Make All Cells the Same Size in Google Sheets
How to Make Columns Bigger in Google SheetsHow to Make Rows Bigger in Google Sheets
How to Lock a Sheet in Google SheetsHow to Make Cells Bigger in Google Sheets
How to Make Charts in Google SheetsHow to Make Bar Graphs in Google Sheets
bottom banner