How to merge or combine cells in Microsoft Excel 2013?
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.
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.
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 option is used to merge the rows of the selected range of cells.