Merge Cells in MS Excel 2013

How to merge or combine cells in Microsoft Excel 2013?

Explanation

To merge/combine a range of cells in the excel file, follow the steps given below.
Step 1: Select the range of cell that you wish to merge.
Step 2: You can merge cell using two options.
Option 1:
Step 1: Right click on the selected cells and click Format Cells option.
Step 2: Format Cells dialog box opens, click Alignment tab. Enable the Merge cell check box and click OK. Selected range of cells will be merged into a single cell as given in the image below.

Option 2: Under Home tab, select Alignment. Click on the drop down near the Merge and Center icon and select the required option.
Merge Cells:
Selected range of cell will be merged into a single cell.

Below image shows the result of selected range of cells merged into single cell using the Merge cell option.

Merge and Center:
Merge and format the data in the center of the merged cell.

Merge Across:
Merge Across option is used to merge the rows of the selected range of cells.

Related Topics