How to Merge Cells in Google Sheets

To merge cells in Google Sheets, select the adjacent cells you want to combine, then choose Format > Merge cells and pick a merge option. Merging creates one larger cell for a heading or label; it does not join the contents of the selected cells. Before you begin, check what is in each cell, because only the upper-left cell’s contents are kept when a range is merged.

What You’ll Need

A Google account with access to the spreadsheet.
The spreadsheet open in Google Sheets in a web browser.
A clear idea of which neighboring cells should become one cell. If any selected cell contains information you need, copy that information somewhere safe first.

You do not need an add-on or a formula. Merging changes the sheet’s layout, so consider whether the merged area will still work with sorting, filtering, or future data entry before applying it.

Step-by-Step

Open the spreadsheet and locate the range. Find the row and columns where you want a larger cell, such as a heading above a small table. Make sure the selection will include only the cells intended for that one heading or label. For example, if the heading should span columns B through D in row 1, the range is B1:D1.
Select adjacent cells. Click the first cell and drag across the range, or click the first cell, hold Shift, and click the last cell. You can also click and drag over the row and column headers if selecting whole rows or columns is appropriate. The cells must form a single rectangular block; separated cells cannot be merged as one range.
Check the contents before merging. Look through every selected cell, not just the one where the heading appears. Google Sheets keeps the content from the upper-left cell of the selected range and removes content from the other cells when they are merged. Copy any other text, numbers, or formulas you want to preserve into another location first.
Open the merge commands. With the range still selected, use the menu at the top of the sheet and choose Format > Merge cells. This menu path is a dependable way to find the options if you do not see the merge icon on the toolbar. The toolbar may show a merge-cells button, but its appearance or location can vary with window size.
Choose the option that matches the selection. Choose Merge all to turn the entire selected rectangle into one cell. Choose Merge horizontally to merge cells across each row separately, or Merge vertically to merge cells down each column separately. If the selected area is just one row, Merge all and Merge horizontally produce the same layout. For one column, Merge all and Merge vertically do the same.
Review any warning and confirm if prompted. If more than one selected cell has content, Sheets may warn that only the upper-left cell’s contents will be kept. Stop if that would discard information you need. Cancel, copy the other contents elsewhere, and then repeat the merge. Do not assume that merging combines words or adds numbers together.
Check the result and format the new cell. Confirm that the merged area covers the intended cells and that the retained text is the correct heading or label. Use the toolbar’s alignment controls to position the text, and adjust wrapping or row height if it is difficult to read. Formatting changes the appearance, but it does not restore content removed from other cells.
Undo or unmerge if the result is wrong. If you have just made the change, use Edit > Undo or press Ctrl+Z on Windows or ChromeOS. On a Mac, press Command+Z. To keep the layout but return to separate cells, select the merged cell and choose Format > Merge cells > Unmerge. Unmerging restores the grid, but it does not bring back content that was discarded during the merge.

For a quick example, suppose B1 contains the title Monthly sales and C1 and D1 are empty. Select B1:D1 and choose Format > Merge cells > Merge all. The title remains in the larger cell spanning those three columns. If C1 or D1 contains a note, move or copy it before merging so you do not lose it.

Common Mistakes

Expecting the contents to combine. A merge changes the cell layout; it does not concatenate text, total values, or combine formulas. Only the upper-left cell’s contents remain. If the goal is to put multiple pieces of text together, keep the cells separate and use a suitable formula or edit the desired combined text in a separate cell instead.
Selecting too large a range. Merging an entire block when you meant to merge just one row can hide the structure of a table. Check the highlighted range before choosing a command. A large selection with Merge all becomes one cell, not a set of individually merged headings.
Choosing the wrong merge direction. Merge horizontally makes one merged cell per row in the selection; Merge vertically makes one per column. Merge all makes one cell for the full selection. If the result looks like one oversized block rather than several row headings, undo and choose the directional option.
Merging cells in a data table. Merged cells can make sorting, filtering, copying, and filling data less predictable. They are usually better suited to decorative titles or labels outside the actual table than to cells within the table’s rows and columns.
Assuming unmerge restores deleted values. Unmerge separates the grid but does not recover the contents that were removed from the other cells. Use Undo immediately if you need to reverse a recent merge, or restore the lost information from a version history or another copy of the sheet.

Tips

Use merges for presentation, not data structure. A merged title above a report can make the sheet easier to scan. For the underlying data, keep one value per cell and use consistent column headers. This makes it easier to sort, filter, create charts, and reuse the data elsewhere.
Consider alternatives for headings. If you want a title centered over several columns but need every cell to remain separate, you can leave the cells unmerged and adjust alignment or place the title in a single cell. Merging is not necessary just to make text look centered, and keeping cells separate can avoid problems in a structured table.
Plan the range before selecting it. Identify the exact starting and ending row and column first. For a banner above columns A through E, for instance, select only the cells in the banner row. Avoid including the first row of actual records by mistake.
Make the retained cell the upper-left cell. Since that is where the surviving content comes from, put the desired title or label there before merging. If the text is currently in another selected cell, move or copy it to the upper-left cell first and verify it before proceeding.
Use Undo as a quick recovery, not as a backup plan. Undo is useful immediately after a mistaken command, but a long sequence of later edits can make it inconvenient to return to the right point. For important sheets, make a copy or use version history before substantial layout changes.

Troubleshooting

The Merge cells command is unavailable. Check that you have selected at least two adjacent cells in one rectangular range. Also check whether you have permission to edit the sheet, whether the cells are protected, and whether the selection includes merged cells in a way that prevents the operation. Try selecting a smaller, unmerged range and opening Format > Merge cells again.

The wrong text or value remains. Sheets retains the upper-left cell’s content, not necessarily the cell you clicked most recently. If the merge just happened, use Undo. Otherwise, unmerge the range and enter or restore the desired value in the correct cell. Before merging again, move any other information you need to keep out of the selected range.

The merged result is one big cell instead of several. The selected range may have been merged with Merge all. Undo the operation, select the same range again, and use Merge horizontally or Merge vertically depending on how you want the cells grouped. Horizontal merges make one merged cell per row; vertical merges make one per column.

You cannot sort or filter the table as expected. Look for merged cells inside the data range. A merged cell can interfere with operations that expect a consistent grid. If the merge is only for a heading, move it above or outside the data table. If it is within the table, consider unmerging it and repeating the relevant label in each row or using another layout.

The text appears cut off or oddly positioned. Merging does not automatically make the content fit or center it. Widen the columns or increase the row height, adjust horizontal or vertical alignment, or turn on text wrapping from the toolbar. If you use wrapping, make sure the row has enough height to display the full text.

Some information disappeared after merging. First try Undo if the merge is still the most recent action. If not, check File > Version history > See version history to find an earlier version, or retrieve the values from a backup or another copy. Restoring an earlier version can also reverse other edits, so review the version and consider copying only the missing information if possible.

Frequently Asked Questions

Can I merge multiple cells at once?
Yes. Select a rectangular range of adjacent cells and choose a merge option. Merge all makes the whole range one cell; the horizontal and vertical options create separate merged cells along the selected rows or columns. Review the range carefully before applying the command.

Does merging cells combine their text or numbers?
No. It keeps the content from the upper-left cell and removes the contents of the other selected cells. Copy any text, numbers, or formulas you need to preserve before merging. If you need to combine text, use a separate cell and a formula or enter the combined text there.

What is the difference between Merge all and Merge horizontally?
Merge all combines the full selected range into one cell. Merge horizontally combines cells across each row separately. For example, selecting A1:C2 and choosing Merge horizontally creates one merged cell for A1:C1 and another for A2:C2.

Can I merge cells that are not next to each other?
No. A merge applies to one contiguous rectangular selection. If you need several separate merged areas, select and merge each area individually, making sure each selection contains only neighboring cells.

How do I undo a merge?
Immediately after merging, use Edit > Undo or Ctrl+Z on Windows or ChromeOS; on Mac, use Command+Z. To separate a merged cell later, select it and choose Format > Merge cells > Unmerge. Unmerge does not recover content that was removed from the other cells.

Can I merge cells in the Google Sheets mobile app?
The steps here are for Sheets in a web browser. The mobile app has a different interface: select the cells, open its formatting controls, and use the cell merge option if it is available in your app version. For the clearest menu path and range control, use Sheets in a desktop browser.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.