Merge Cells in MS Excel 2013

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.
Option 1:
Step 1: Right click on the selected cells and click Format Cells option.merge cells format cells ms excel 2013
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.
merge cells1 ms excel 2013
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.
merge cells ms excel 2013
Below image shows the result of selected range of cells merged into single cell using the Merge cell option.
merge cells output ms excel 2013
Merge and Center:
Merge and format the data in the center of the merged cell.
merge and center ms excel 2013
Merge Across:
Merge Across option is used to merge the rows of the selected range of cells.
merge across cells ms excel 2013

Related Topics