What merging columns actually does

Merging columns in Google Sheets combines two or more adjacent columns into a single wider column. The merged cell spans across the space where those separate columns used to be. When you merge, Google Sheets keeps the content from the leftmost column and discards the text from the columns to its right — so you need to move or copy any data you want to keep before you merge.

Merging is useful when you have a header that should span multiple columns, like a title row for a section of your data. It is not useful for combining the actual data inside those columns — that requires a different approach. Many people confuse merging with concatenating (joining text together), which are two separate things.

Key Takeaways

  • Merging combines adjacent columns into one wider column, but Google Sheets keeps only the leftmost cell's content and deletes the rest.
  • Before you merge, copy or move any data from the columns on the right that you need to keep, because it will be deleted otherwise.
  • Select the columns you want to merge, then use the merge cells button in the toolbar or the Format menu.
  • Unmerging a cell splits it back into separate columns, but does not restore the data that was deleted during the original merge.

How to select and merge columns

Start by clicking on the column header of the first column you want to merge. The entire column will highlight in blue. Then hold Shift and click on the last column header you want to include in the merge. All columns from the first to the last will now be selected.

Once your columns are selected, look at the toolbar at the top of the screen. Find the icon that looks like a small grid or box with lines through it — this is the merge cells button. Click it, and a dropdown menu will appear with four options: merge all, merge vertically, merge horizontally, and unmerge. For columns, choose "merge all" or "merge horizontally" depending on what you see in your version. The columns will combine into a single wider column when ready.

If you do not see the merge button in your toolbar, go to the Format menu at the top, select "Merge cells", and then choose your merge type from the submenu. This route works the same way as using the toolbar button.

Saving data before you merge

The most common mistake is merging columns without first moving the data you want to keep. When columns merge, Google Sheets keeps only what was in the leftmost column and permanently deletes the content of the columns to the right. If you have important information in those columns, it will be gone.

Before you merge, decide what data matters. If you have text in column B that you need, copy it to a temporary location — another sheet, a text file, or even a different part of your current sheet. Paste it back after the merge if you need it. If you are merging columns that contain numbers you want to add together, use a formula like =A1+B1+C1 in a new cell first, then copy that result somewhere safe before you merge.

Merging only part of a column

You do not have to merge entire columns from top to bottom. You can merge just a few cells in a row if you want a header to span multiple columns while keeping the columns separate below it.

To do this, click on the first cell you want to merge (for example, A1), then hold Shift and click on the last cell in that row (for example, C1). Only those three cells will highlight. Now click the merge button or go to Format > Merge cells. Only those cells will merge, and the columns below them will stay separate. This is the most common use — merging a header row across several columns while leaving the data columns intact below.

Unmerging cells and what happens to your data

To unmerge cells, click on the merged cell to select it. Then click the merge button in the toolbar and choose "unmerge", or go to Format > Merge cells > Unmerge. The merged cell will split back into separate columns.

Important: unmerging does not bring back the data that was deleted when you originally merged. If you merged columns A, B, and C and only kept the text from A, columns B and C will be empty when you unmerge them. The only way to recover that lost data is if you saved it somewhere else before the merge, or if you undo the merge when ready by pressing Ctrl+Z (or Cmd+Z on Mac) before doing anything else.

When merging causes problems

Merged cells can create issues if you plan to sort, filter, or rearrange your data later. Google Sheets sometimes behaves unpredictably with merged cells in the middle of a dataset — sorting might skip them, or filters might not work as expected. For this reason, many people avoid merging data cells and only merge header rows at the very top of a sheet.

If you are building a sheet that other people will use, merged cells can also be confusing. Someone might not realize that what looks like one column is actually three merged together, and they might try to enter data in what they think is a separate column. For shared sheets, it is often clearer to leave columns separate and use formatting (like background color or bold text) to group related columns visually instead.

Alternatives to merging for organizing columns

If you want columns to look grouped without actually merging them, you can use formatting instead. Select the columns you want to highlight, then use the fill color button to give them the same background color. You can also make the header row bold, larger, or a different color to make it stand out. This keeps your columns separate and functional while still showing visually that they belong together.

If you want to combine data from multiple columns into one cell (like joining a first name and last name), use the CONCATENATE function or the ampersand operator instead of merging. For example, =A1&" "&B1 will combine the text from A1 and B1 with a space between them, and you can put this formula in a new column. This preserves all your original data and is much more flexible than merging.

Frequently Asked Questions

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

No. Google Sheets only merges adjacent columns — they must be side by side with no gaps. If you need to work with non-adjacent columns, you can copy them to be next to each other first, merge them, then move the merged result back to where you need it.

What happens to formulas when I merge cells?

If the leftmost cell contains a formula, it will stay. If the cells to the right contain formulas, they will be deleted along with their content. Copy any formulas you need to another location before merging, or use a single formula in one cell that references the data you need instead of merging multiple cells.

Can I merge rows instead of columns?

Yes. The process is identical — select the row headers instead of column headers, then use the merge button. The same rules explore: only the leftmost cell's content is kept, and the rest is deleted. Merging rows is less common than merging columns, but it works the same way.

Why does my merged cell look misaligned with the rest of my data?

Merged cells sometimes display differently depending on your zoom level or screen size. Try adjusting the column width by dragging the border between column headers, or check that your text alignment is set to left, center, or right consistently across your sheet. If the merged cell still looks wrong, unmerge it and use formatting instead.

Can I merge cells in a protected sheet?

It depends on the protection settings. If the sheet is protected but merging is allowed, you can merge. If merging is blocked, you will see a message saying the sheet is protected. Ask the sheet owner to unprotect it temporarily, or have them merge the cells for you if you do not have permission to edit protection settings.