What merging cells does and when you need it

Merging cells combines two or more adjacent cells into one larger cell. When you merge cells, the spreadsheet treats them as a single unit — you can type across the merged space, and the text will sit in the middle rather than confined to one column. The merged cell keeps only the content from the top-left cell; anything in the other cells disappears unless you copy it elsewhere first.

You merge cells most often to create a title that spans multiple columns, to label a section of your data, or to make a form-like layout where a question or instruction takes up more visual space than a single cell would. Merging is useful for presentation, but it can make a spreadsheet harder to sort, filter, or reorganize later — so use it sparingly and only in areas where you won't need to rearrange data.

Key Takeaways

  • Merging cells combines multiple cells into one; the merged cell keeps only the content from the top-left cell and deletes the rest.
  • Select the cells you want to merge by clicking the first cell and dragging to the last, or by clicking the first and shift-clicking the last.
  • Open the Format menu, choose Merge cells, and pick the merge style that matches what you need — most people use "Merge all".
  • Avoid merging cells in columns you plan to sort or filter, because merged cells can break those features or produce unexpected results.
  • To unmerge cells later, select the merged cell, open Format, choose Merge cells, and click Unmerge.

How to select the cells you want to merge

Start by clicking the first cell you want to include in the merge. This is usually the top-left cell of the range. Hold down your mouse button and drag to the last cell you want to merge, then release. The cells will highlight in blue to show they are selected.

If the cells are far apart or you prefer not to drag, you can click the first cell, then hold Shift and click the last cell in the range you want. This selects everything in between. You can merge cells horizontally (across columns), vertically (down rows), or in a rectangle (across columns and down rows at the same time).

Opening the merge menu and choosing your merge style

With your cells selected, click the Format menu at the top of the sheet. A dropdown list will appear. Look for the option that says Merge cells and click it. A submenu will open showing four choices: Merge all, Merge horizontally, Merge vertically, and Unmerge.

Merge all is the most common choice — it combines all your selected cells into one. Merge horizontally merges only cells in the same row; use this if you have selected multiple rows and want each row to merge separately. Merge vertically merges only cells in the same column. Click the option that matches what you need, and the cells will merge when ready.

What happens to the content when you merge

When you merge cells, Google Sheets keeps only the text or data from the top-left cell in your selection. Any content in the other cells is deleted. If you have important information in those other cells, copy it to a safe location before you merge.

After merging, the text from the top-left cell will be centered in the merged space by default. You can change the alignment by selecting the merged cell, opening Format again, and choosing Alignment to move the text to the left, right, top, bottom, or any combination. You can also change the font, size, or color of the text in a merged cell the same way you would in any other cell.

Why merged cells can cause problems with sorting and filtering

Merged cells do not work well with sorting or filtering. If you merge cells in a column that you later want to sort, Google Sheets may refuse to sort, or it may sort in unexpected ways because the merged cell breaks the normal column structure. Filtering can also behave strangely when merged cells are present.

For this reason, avoid merging cells in any column or row that contains data you might need to reorganize later. Merging works best for titles, labels, and headers that sit above or beside your actual data — not within the data itself. If you have already merged cells and now need to sort or filter, unmerge first, reorganize your data, and then merge again if you want.

How to unmerge cells

To separate a merged cell back into individual cells, click on the merged cell to select it. Open the Format menu, click Merge cells, and then click Unmerge. The merged cell will split back into its original separate cells. The content that was in the merged cell will stay in the top-left cell; the other cells will be empty.

Unmerging does not restore any content that was deleted when you first merged the cells. If you need that content back, you will have to type it in again or undo the original merge action when ready after it happens by pressing Ctrl+Z (or Cmd+Z on Mac).

Common mistakes and how to avoid them

The most common mistake is merging cells that contain important data in more than one cell, then losing that data when only the top-left content survives. Always check what is in each cell before you merge, and copy anything you want to keep to a different location first.

Another frequent problem is merging cells in a data table, then finding that sorting stops working. If you need a title for your table, put it in a row above the table and merge that row instead. Keep your actual data unmerged so you can sort and filter freely. A third mistake is merging cells across too many columns or rows, which can make your spreadsheet look cluttered and hard to read. Merge only as much as you need for clarity.

Frequently Asked Questions

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

No. You can only merge cells that are adjacent — touching each other horizontally, vertically, or in a rectangle. If you select cells that are separated by empty space or other cells, the merge option will not work.

What happens to formulas when I merge cells?

If the top-left cell contains a formula, it will stay in the merged cell. If other cells in the merge contain formulas, those formulas will be deleted. Copy any formulas you need to a different location before merging.

Can I merge cells in a shared spreadsheet?

Yes, you can merge cells in a shared sheet the same way you would in your own sheet. However, if multiple people are editing at once, merging can sometimes cause display issues or conflicts. It is safer to merge cells before sharing, or to merge in areas where no one else is working.

How do I center text in a merged cell?

Select the merged cell, open Format, click Alignment, and choose the horizontal and vertical alignment you want. Most people choose center for both to put text in the middle of the merged space.

Will merging cells change the size of my columns or rows?

Merging does not automatically resize columns or rows. The merged cell will be as wide as all the columns it spans and as tall as all the rows it spans. If you want the merged cell to look a certain size, you may need to manually adjust the column widths or row heights before or after merging.