Unmerge cells for MS Excel

Unmerge cells:

• Click on the cell B2 (the cell that merged before). 
• On the Home tab,  in the Alignment group,  click on the down arrow next to the Merge and Center icon. 
• Select Unmerge Cells.  The cell B2 is now separated into 3 cells. 

Merge cells for MS Excel

Merge cells:

• Type the words "Items Price" into cell B2 of a spreadsheet. 
• Highlight the cells B2,  B3 and B4
• On the Home tab,  in the Alignment group,  locate the Merge and Center icon. 
• Click the down arrow to see the following options :
• Click on Merge & Center.  The three cells will then become one - B2,  to be exact!

Merge and Unmerge Cells (Columns) for MS Excel

Merge and Unmerge Cells (Columns) :
Studies the spreadsheet below before we start our tutorial on merge cells in Excel 2010 :
          If you look at Row 2, you'll see that the "Items  Price " heading stretches across three cells.  This is not three separate cells,  with a color change for each individual cell.  The B2, B3 and EH cells were merged. 

Merge several cells for MS Excel

Merge several cells 

• Select the cell that you wish to merge to become one cell. 
• On the Home tab,  in the Alignment group,  dick the Merge & Center icon.  Shrink the text into one cell
• Type the data you requirebinto the cell and press Enter,  
• Right-click on the selectedvcells,  click Format Cells. 

From the Format Cells dialog box displayed,  dick on the Alignment tab.
Under the Text control section,  tick the Shrink to fit check box and click on OK. 

Wrap multiple lines of data in a cell for MS Excel

Wrap multiple lines of data in a cell

• Type the text The Ultimate Guide to Excel 2010 into the cell C5 and press Enter.  The entry will appear as one long line that does not fit into the cell. 
• Select the cell C5 and then on 5he Home tab,  in the Alignment group,  click the Wrap Text tonight.  The text will wrap as follow :

Change the orientation of data cells for MS Excel

Change the orientation of data cells
Select the cell,  or cells,  you wish to change.
On the Home tab,  in the Alignment group,  click the
Orientation icon.  You will see a drop down menu allowing you to format the cell orientation.
Select any one of the command. Experiment with applying some of the other orientation effects.

Align data between the top and bottom of a cell

Align data between the top and bottom of a cell.

• Select the cell or cells,  you wish to align, 
• On the Home tab,  in the Alignment group,  click the Top Align icon to align data in the top position of the cell. 
• Click on the Middle Align icon to centralized data vertically in the cell. 
• Click the Bottom Align icon to align data in the bottom position of the cell.