Wednesday, 5 March 2014

Merge and unmerge cells in Microsoft Excel 2010


A merged cell is created by combining two or more horizontal or vertical adjacent cells.
Merging is a useful tool when combining data from other sources.

1. Select two or more adjacent cells that you want to merge.
  
2. From the [Home] tab, in the [Alignment] group, click the arrow next to [Merge & Center].
Cells can be merged in three different ways: Merge & Center, Merge Across, Merge Cells.
Select your option. See diagrams below:

Note: Make sure the data that you want to display is within the upper-left cell of the selected range. Only the data in this cell will remain in the merged cell. Data in all the other cells of the selected range will be deleted.

        

3. Click OK.

To unmerge cells, do the following:
1. Select the merged cell that you want to unmerge.
2. To split the merged cell, click [Merge & Center], or click the arrow next to [Merge & Center], and then click [Unmerge Cells].