Merge Cells

 

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. Go here to concatenate (join) strings in Excel.

1. Enter a label in cell A1.

Enter a Label in Excel

2. Select the range A1:G1.

Select the Range

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

Click Merge & Center

Result:

Merged Cells in Excel

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.

Select Multiple Cells

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

Click Merge & Center

Result:

Excel Deletes All Other Values

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.