Merge Cells

Merging cells is often used when a title is to be centered over a particular section of a spreadsheet. When a group of cells is merged, only the text in the upper-leftmost box is preserved.

Merge Cell menu in Ribbon

Excel XP and Excel 2003	Excel 2010
Excel 2007	Excel 2011 (Mac)
Excel 2008 (Mac)	Excel 2013

To merge a group of cells:

1.      Highlight or select a range of cells.

2.      Right-click on the highlighted cells and select Format Cells.

3.      Click the Alignment tab and place a checkmark in the checkbox labeled Merged Cells.

Or

1.      Highlight or select a range of cells.

2.      Goto home ribbon, select merge cell option from Alignment group

Or you can use shortcut key

Types of Merge cells

Merge & Center (Alt H+M+C)	combine and center the contents of the selected cell in a new larger cell. This is a great way to create a label that span multiple column
Merge Across (Alt H+M+A)	merge selected cells in the same row into one larger cell
Merge Cells (Alt H+M+M)	merge cells into one cell
Unmerge (Alt H+M+U)	Split the merged cells

follow us on http://arivilm.blogspot.in/

like us on https://www.facebook.com/Arivilm2501/