Merging cells combines multiple boxes into one larger box

Merging cells in Google Sheets combines two or more adjacent cells into a single cell. When you merge cells, the content from the leftmost cell stays, and anything in the other cells disappears. The merged cell stretches across the space where all those cells used to be, which is useful when you want a title to span several columns or when you're organizing data into visual sections.

Merging is different from straightforward making a cell wider. A merged cell actually removes the grid lines between cells and treats the whole area as one unit. This matters because you can't enter data into the individual cells that were merged — they're now one cell.

Key Takeaways

  • Select the cells you want to merge by clicking and dragging across them, then use the merge cells button in the toolbar or the Format menu.
  • When you merge cells, only the content in the top-left cell remains; anything in the other cells is deleted.
  • You can merge cells horizontally (across columns), vertically (down rows), or in a grid pattern (both directions at once).
  • Unmerging cells restores the original grid and puts the content back into the top-left cell only.

How to select and merge cells step by step

Start by clicking on the first cell you want to merge. Hold down your mouse button and drag to the last cell in the group you want to combine. For example, if you want to merge cells A1 through D1 to create a wide title across four columns, click on A1 and drag right to D1. The cells you select will highlight in blue.

Once your cells are selected, look for the merge cells button in the toolbar. It looks like a small grid with cells joining together. Click that button, and a dropdown menu appears with four options: merge all, merge horizontally, merge vertically, and unmerge. Choose "merge all" for most situations — this combines all your selected cells into one. The merged cell will be the size of all the cells you selected combined.

If the merge button isn't visible in your toolbar, go to the Format menu at the top, click it, then select "Merge cells" and choose your merge type from the submenu.

What happens to your data when you merge

When you merge cells, Google Sheets keeps only the content from the top-left cell. If you merge A1 through D1, and A1 contains "Sales Report" while B1 contains "2024", only "Sales Report" remains after the merge. The "2024" is deleted. This is why you should always check what's in each cell before merging — you won't get a warning that data will be lost.

The content that remains is left-aligned by default in the merged cell. You can change the alignment after merging by selecting the merged cell, going to Format, then choosing Align and picking center, right, or another option. Many people center text in merged cells used for titles.

Merging cells horizontally, vertically, or both

The merge dropdown gives you three merge options beyond "unmerge." Merge horizontally combines cells across columns in the same row — useful for titles that span multiple columns. Merge vertically combines cells down the same column in different rows — useful for labels that explore to several rows of data. Merge all combines cells in both directions at once, creating a large rectangular merged area.

Choose based on what you're trying to do. If you're creating a header row that spans your entire data table, use merge horizontally. If you're labeling a section of rows on the left side, use merge vertically. If you're creating a large box for a title or note that takes up multiple rows and columns, use merge all.

When merging cells causes problems

Merged cells can make sorting and filtering harder. If you sort a column that contains merged cells, the merge might break or the sort might not work the way you expect. For this reason, avoid merging cells in data columns — only merge cells in header rows or label areas that you won't be sorting.

Merged cells also make it harder to copy and paste data accurately. If you copy a merged cell and paste it elsewhere, the paste might not work as expected, or it might unmerge the cell. If you're working with a spreadsheet that other people will edit, consider whether merged cells will confuse them or make their work harder.

How to unmerge cells and restore the grid

To unmerge cells, select the merged cell and click the merge cells button in the toolbar. From the dropdown, select "unmerge." The merged cell splits back into its original separate cells. The content stays in the top-left cell, and the other cells become empty again.

You can also unmerge through the Format menu: click Format, select "Merge cells," then choose "Unmerge." This restores the grid lines and lets you enter data into each cell individually again.

Merged cells in templates and shared spreadsheets

If you're using a template or working in a spreadsheet someone else created, you might see merged cells already in place. You can work around them by entering data in the cells that aren't merged, or you can unmerge them if you need to change the layout. Just remember that unmerging will affect how the spreadsheet looks, so check with anyone else using it before you make changes.

When you're building a spreadsheet that others will use, use merged cells sparingly and only for titles, headers, and labels. This keeps the spreadsheet easier to edit and less likely to cause confusion or errors when someone else works with it.

Frequently Asked Questions

Can I merge cells that aren't next to each other?

No. You can only merge cells that are adjacent — touching each other in a rectangle. You can't merge A1 and C1 while skipping B1, and you can't merge cells from different parts of the spreadsheet at the same time. If you need to group non-adjacent cells visually, use borders or background colors instead.

What if I accidentally merged the wrong cells?

Click the merged cell to select it, then click the merge cells button and choose "unmerge." This splits the cells back apart. Your data will be in the top-left cell, and the others will be empty. You can then select the correct cells and merge those instead.

Does merging cells change how my data sorts or filters?

Yes, merged cells can interfere with sorting and filtering. Google Sheets may not sort correctly if merged cells are in the column you're sorting, and filters might behave unexpectedly. Keep merged cells out of your actual data — use them only in header rows or label areas that you won't sort.

Can I merge cells and still enter different data in each one?

No. Once cells are merged, they become one cell. You can only enter data once, and it appears across the entire merged area. If you need separate data in separate cells, don't merge them.