Lesson 48: How to Merge – Merge Cells in Excel

You can use the Merge Cells increment to merge cells into another larger cell in Excel. But this feature keeps only the value of the upper left cell and deletes all other values. Use the Excel CONCATENATE function to concatenate strings.

How to merge cells in Excel

first. Enter the following text in cell A1.

2. Select the area A1:G1.

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

Result:

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

first. For example, enter the following value in cells A1, B1 and C1 and select these cells.

2. On the tab Homein group Alignmentpress Merge & Center.

Result:

Note: on tab Homein group Alignmentpress Merge & Center again to unmerge the cells (cells B1 and C1 will be empty). Press Ctrl + z to undo.

In addition, you can also view many other excel articles here.