Change Alignment Using the Ribbon : Cell Format « Format Style « Microsoft Office Excel 2007 Tutorial






Select a cell or a range. 
           Click the Home tab. 
           Click Align Left, Center, or Align Right to align cell contents left to right.
Click the Home tab. Click Align Left, Center, or Align Right to align cell contents left to right.
Click Top Align, Middle Align, or Bottom Align to align cell contents from top to bottom.
Click Top Align, Middle Align, or Bottom Align to align cell contents from top to bottom.
Click Decrease Indent or Increase Indent to align cell contents to the left or right.
Click Decrease Indent or Increase Indent to align cell contents to the left or right.
Click Orientation, 
           and then click Angle Counterclockwise, Angle Clockwise, Vertical Text, Rotate Text Up, 
           or Rotate Text Down to rotate cell contents.
Click Orientation, and then click Angle Counterclockwise, Angle Clockwise, Vertical Text, Rotate Text Up, or Rotate Text Down to rotate cell contents.
Check the result.
Check the result.








3.4.Cell Format
3.4.1.Change Alignment Using the RibbonChange Alignment Using the Ribbon
3.4.2.Change Alignment Using the Format Dialog BoxChange Alignment Using the Format Dialog Box
3.4.3.Control the Flow of Text in a CellControl the Flow of Text in a Cell
3.4.4.Apply(Copy) a Format Style Using the Format PainterApply(Copy) a Format Style Using the Format Painter
3.4.5.Add or Remove a BackgroundAdd or Remove a Background
3.4.6.Find or Replace Cell FormattingFind or Replace Cell Formatting
3.4.7.Replace text and formattingReplace text and formatting