Merge Cells

In your Excel worksheets, you may often need to merge two or more cells into one large cell. For example, you may want to combine several cells for a better data presentation or structure. In other cases, there may be too much content to be displayed in one cell, and you decide to merge it with adjacent blank cells.

There are various ways you can merge cells in Excel.

This page illustrates how to merge selected cells into one large cell. This can be useful if you want to make clear that a label in Excel applies to multiple columns.

Before you start: this feature only keeps the value in the upper-left cell and deletes all other values. Use the CONCATENATE function in Excel to concatenate (join) strings.

1. Enter a label in cell A1.

2. Select the range A1:G1.

3. On the Home tab, in the Alignment group, click Merge & Center.

Result:

Note: on the Home tab, in the Alignment group, use the 6 alignment buttons to change the alignment of text in a cell.

Remember, Excel only keeps the value in the upper-left cell and deletes all other values.

1. For example, enter a label in cell A1, B1 and C1 and select these cells.

2. On the Home tab, in the Alignment group, click Merge & Center.

Result:

Note: on the Home tab, in the Alignment group, click Merge & Center again to unmerge cells (cell B1 and C1 will be empty). Press Ctrl + z to undo this action.