iSumsoft » Resources » Office » 3 Ways to Merge Cells in Excel Worksheet

3 Ways to Merge Cells in Excel Worksheet

In Microsoft Excel, merging is the process of creating one cell out of two or more selected cells. This guide will show you how to merge multiple columns or rows to in a single cell in Excel.


Option 1: Merge Cells using Merge & Center Tool

To merge cells using the Merge and Center tool on the ribbon, here's how:

Step 1: Select the cell range you want to merge.

select cell range

Step 2: Go to Home tab, click Merge & Center command.

merge and center

The selected cells will be merged, and the text will be centered.

merge cells settings

Option 2: Merge Cells using Format Cells Settings

To merge cells using the controls in the Alignment tab of the Format Cells dialog box, here's how:

Step 1: Select the cell range you want to merge.

Step 2: Right-click on the selected cells, and click on Format Cells...

format cells

Step 3: In the Format Cells dialog box, select Alignment tab, then check on Merge cell checkbox.

merge cells

Option 3: Merge Cells using Shortcut Key: Alt+Enter

Once you have used one of the options shown above, you can merge cells in Excel by simply pressing shortcut key: Alt+Enter. When merging cells and more than one of the selected cells contains data, the data in the upper-left or upper-right cells is kept and all remaining data is deleted.

When it prompts this warning dialog. Click on OK to confirm merge cells.

merge cells