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.

Click Merge & Center

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

The selected cells merged

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 options above shows, 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 deletes all remaining data.

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

Merge cells in Excel