- Both tables work in the same way, with only a few key differences.
- Merge cells in Microsoft Excel
- Merge cells in Google Sheets
Both tables work in the same way, with only a few key differences.
In Microsoft Excel and Google Sheets, it is a single cell created by merging or merging two or more separate cells. Both tables merge cells horizontally, vertically, or both.
This procedure works in the current version of Google Sheets and in all versions of Microsoft Excel since Excel 2010.
Merge cells in Microsoft Excel
Excel provides one-click access to the Merge Cells tool. Just select the cells you want to merge – they must be horizontally or vertically adjacent – then press the button Confluence and Center in the Alignment section on the Home tab.
When you click the button, the selected cells are merged by default and the contents in the top-left cell are centered over the entire merge. To change this behavior, click the down arrow next to the button and choose an alternative behavior:
- Confluence and Center : default behavior; merges cells, then centers all content that appears in the rightmost or topmost cell of the area.
- merge via : Merges cells but does not center their contents. Only works at driving level. For example, if you selected a block of four rows by four columns, this option will result in four rows with one column.
- Merge cells . Merges cells into one large block. For example, if you selected a block of four rows by four columns, this option will result in one block that is four rows high and four lines wide.
- Merge cells . If you selected a merged cell, the cells will be merged when you use this option.
While the Merge & Center feature is most commonly used to consolidate row-level headings in reports, you can also merge cells vertically, or even rectangles. However, you cannot merge non-adjacent cells.
Merge cells in Google Sheets
Like Microsoft Excel, Google Sheets also offers one-click access to the merge feature. Select the cells you want to merge and click the merge icon in the toolbar – it looks like a square with arrows pointing inward.
The default behavior is to merge all cells, but clicking the down arrow next to the icon opens additional merge types:
- Unite all : default behavior. Renders all cells in one block, regardless of the number of rows and columns within the range.
- Merge horizontally . Merges cells along the row axis. If you have more than one row selected, this option will make each row stand alone and merge the columns into one or more single row cells.
- Merge vertically : Merges cells along the column axis. For example, if you select a range of six rows by six columns, this option displays six merged cells, each one column wide and six rows high.
- Detach . Removes the merge in the affected cells.
Merges in Google Sheets only keep the contents of the top-left cell within the merged range. You can only merge cells into contiguous blocks.
If you lose data in a mail merge, use the undo feature in Microsoft Excel or Google Sheets. However, if you cannot undo the operation, deleting the cells will not restore the data because the data is deleted as part of the merge procedure.