Google Sheets: How to Merge Cells in a Table

To merge cells in Google Sheets, select the adjacent cells, then choose Format > Merge cells and pick Merge all, Merge horizontally, or Merge vertically. Check the selected cells first: when cells are merged, only the top-left cell’s content in each merged group is kept, and content in the other cells is removed. Merging is most useful for a heading or label, not for cells in the middle of data you need to sort or filter.

What You’ll Need

A Google account with access to the spreadsheet and permission to edit it.
A web browser with the Google Sheets file open.
A clear idea of which cells should become one cell. If any selected cells contain information, copy or move it somewhere safe before merging.

Step-by-Step

Open the spreadsheet and locate the cells. Go to Google Sheets in your browser and open the file. Find the group of adjacent cells you want to combine. Merging works on a rectangular selection; it does not combine separate, nonadjacent cells into a single cell. For example, to make one heading across columns A through D, select A1:D1.
Check the contents before changing the range. Look at every cell in your selection, not just the first one. A merged cell displays one value, so Google Sheets keeps the contents in the top-left cell of each group and removes the contents of the other cells in that group. If those other values matter, copy them to another location or make a copy of the sheet first.
Select the range. Click the first cell and drag across and down to the last cell you want to include. You can also click the first cell, hold Shift, and click the last cell in the rectangular range. For a large range, click the name box to the left of the formula bar, type a reference such as A1:D1, and press Enter. Confirm that the highlight covers exactly the cells you intend to merge.
Open the merge options. Choose Format > Merge cells from the menu at the top of Sheets. Depending on the selection, Sheets may also show a merge-cells button in the toolbar. The Format menu is a dependable way to see the available choices and their names.
Choose the merge type that matches the layout. Select 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. For a single heading across a row, Merge all and Merge horizontally have the same result. For several rows, they do not.
Review the result. The selection becomes a merged cell or a set of merged cells. Check that the intended label is visible and that it has not obscured information you needed. If the text looks crowded, adjust the column width or row height, or use the text-wrapping controls. You can change alignment from the toolbar after the merge.
Undo or unmerge if needed. If the result is not right, use Edit > Undo immediately, or press Ctrl+Z on Windows or Chromebook. On Mac, use Command+Z. To separate merged cells later, select the merged cell or range and choose Format > Merge cells > Unmerge. Unmerging restores the cell grid, but it does not bring back values that were discarded when the cells were merged.

For example, suppose A1 contains the heading Monthly Sales and B1:D1 are blank. Select A1:D1 and choose Format > Merge cells > Merge all. The heading will occupy the wider merged area. If B1, C1, or D1 contains a date or note, copy it elsewhere first; otherwise, that value will be removed as part of the merge.

Common Mistakes

Merging cells that contain multiple values. A merged cell cannot display all the separate contents as independent cell values. Sheets retains the top-left content for each resulting merged group and discards the rest. Do not assume the other entries will move into the new cell, be joined together, or remain available after unmerging.
Choosing Merge all for a multirow range by mistake. Merge all turns the entire selection into one cell. If you select A1:D3, for example, the result is one large cell, not one merged cell per row. Use Merge horizontally if your goal is to create one merged group in each selected row.
Merging the data area of a list. Merged cells can make a dataset harder to sort, filter, paste into, or use with formulas. Keep each record in its own row and each field in its own column. If you want a prominent table title, put it in a heading row above the data and merge only that heading row.
Selecting more cells than intended. A range that extends one column too far can combine a label with cells meant for separate data. Check the highlighted boundaries and the range reference before choosing a merge option.
Expecting unmerge to restore deleted content. Unmerge separates the cell layout, but does not reverse the loss of values from other cells. Undo promptly if you merged by accident; otherwise, use version history or a saved copy to recover earlier content.

Tips

Use merging for presentation, not data structure. A merged heading can make a report easier to scan, but it is usually a poor fit for the rows that contain the report’s actual records. Keeping the data in a regular grid makes sorting, filtering, and copying more predictable.
Pick the option by picturing the final grid. Merge all makes one cell from the whole highlighted rectangle. Merge horizontally makes one cell per row. Merge vertically makes one cell per column. If you are unsure, select a small sample range first and confirm the result before applying the same layout elsewhere.
Center and wrap the heading after merging. A merged heading may look better with horizontal and vertical alignment adjusted from the toolbar. If the words do not fit, try text wrapping or increase the row height. Do not widen many data columns just to accommodate a decorative heading if that makes the rest of the sheet harder to read.
Keep an unmerged copy of important information. Before merging cells in a shared or business-critical sheet, duplicate the tab or copy the values elsewhere. This is especially helpful when you are unsure whether a range contains formulas, notes, or values entered by someone else.
Use borders and formatting as alternatives. If you only want a heading to appear centered across several columns, Sheets offers a merge option, but borders, fill color, bold text, and alignment can also create visual grouping without combining cells. Those options can be safer for a range that needs to remain easy to sort or edit.

Google Sheets and Microsoft Excel both have merge-cell features, but their menus and behavior around certain worksheet operations can differ. These steps use the Google Sheets browser menus; in Excel, do not assume the same menu path applies.

Troubleshooting

The merge command is unavailable or grayed out. Check that you have editing permission rather than view-only access. Make sure you have selected a valid rectangular range of adjacent cells, and check whether the sheet or range is protected. If you cannot edit the protected area, ask the file owner to change the protection or grant access.
Sheets says the selection cannot be merged. Review the highlighted cells and select a straightforward rectangle. A selection made from separate, nonadjacent ranges cannot become one merged block. If the range includes an existing merged cell, unmerge the existing area first if that is appropriate, then select the new range.
Some values disappeared after merging. If the merge was your last action, choose Edit > Undo or press the appropriate undo shortcut. If you have made more edits since then, check File > Version history > See version history for an earlier version. Restoring an older version can affect other changes, so review the version and consider copying the needed information instead of restoring the whole file.
The heading is not centered or fully visible. Select the merged cell and adjust horizontal and vertical alignment from the toolbar. Use text wrapping if the heading is long, or adjust the row height. If the words are clipped, check the font size and the width of the merged area as well.
Sorting or filtering behaves unexpectedly. Look for merged cells inside the data range. Unmerge them if possible and put labels in separate cells or in a heading row outside the filtered records. Keep a copy before changing a shared sheet, especially if other people rely on its formatting.
Unmerge is missing or does not seem to work. Select the merged cell itself, not only a nearby cell, then open Format > Merge cells and choose Unmerge. If the menu still does not offer it, check that the selection includes the merged area and that you have permission to edit the sheet.

Frequently Asked Questions

Can I merge cells in Google Sheets without losing data?
Not if the selected cells contain different values that you want to keep as separate cell contents. Copy those values elsewhere first. The top-left cell’s content is kept for each merged group; other contents in that group are removed.

What is the difference between Merge all and Merge horizontally?
Merge all combines the entire selected rectangle into one cell. Merge horizontally combines cells across each selected row separately. If you select several rows, the two options produce different layouts.

Can I merge cells that are not next to each other?
No. To create a merged cell, select one adjacent rectangular range. Separate ranges cannot be joined into a single cell by merging.

Can I merge cells on the Google Sheets mobile app?
The app may use a different interface from the browser steps here. Select the cells, open the formatting controls, and look for the cell merge option. Menu placement can vary by device and app version; for the exact browser path, use Format > Merge cells.

Does unmerging restore the original values?
No. Unmerge restores separate cells, but it does not restore values removed during the merge. Use Undo right away or recover the information from a copy or version history.

Should I merge cells in a sortable table?
Usually not within the rows of data. Merged cells can interfere with sorting, filtering, and consistent editing. Keep the records unmerged and, if you want a title, place a merged heading above the data area.

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.