All About Alignment in Excel

Shuffling values with in cell boundaries called Alignment , several kind of alignment in new version of ms office 2013 some are named as Right Align , Left Align , Center , Top , Bottom etc we have learn every thing about alignment,

Also we have learn how to increase , decrease indent of content , text orientation , Wrap Text & Merge & Center ,  try to cover additional alignment in which you will learn in detail .

All Types of Alignment : 

Short-Key Top Align alt+h+a+t

Top Align : Shifted Cell Value to the top of cell border , either it was already in center or right align but when you click on top align value shifted at the top in the same direction.

Short-Key middle Align alt+h+a+m

Middle align : shifted text to the centered , in the middle of top and bottom of the cell.

Short-Key bottom Align alt+h+a+b

Bottom Align : Cell value at the bottom bottom.

 Short-Key right Align alt+h+a+r

Right Align :  shifted value to right corner.

Short-Key center Align alt+h+a+c

Center : Centered the text.

Short-Key left Align alt+h+a+l

Align Left : Align content to the left.

Wrap Text.

Short-Key wrap text ctrl+shift+w

Force the cell content to remain in the same cell is know as  WRAP TEXT.

Work with Merging.

Merge & Center:

Short-Key merge & center : alt + h+m+c.

To combining and Centered Cells content in new large cell known as Merge & Center. 

Merge Across

Short-Key merge & Across : alt + h+m+a.

Selection of Cells into one row in a large cell shape.

Merge Cells

Short-Key merge Cells: alt + h+m+m.

Selection of cells merge into one large cell. 

unMerge Cells.

Short-Key of Unmerge Cells : alt + h+m+u.

Split selected merged cell into multiple cells or say this remove the merge activity of any area.

Examples are : 

alignment in Excel