Control the Flow of Text in a Cell : Cell Format « Format Style « Microsoft Office Excel 2007 Tutorial

1. Microsoft Office Excel 2007 Tutorial
2. Format Style
3. Cell Format

Select a cell or a range. 
           Click the Home tab. 
           To center cell contents across selected columns, 
           click the Merge & Center button arrow. 
           Click one of the options: Merge & Center, Merge Across, Merge Cells, Unmerge Cells,

To wrap text in a cell, click the Wrap text button.

To set multiple alignment options or shrink text to fit in a cell, 
           click the Alignment Dialog Box Launcher.

The Format Cells dialog box opens and select the Alignment tab. 
           Choose Wrap text moves the text to multiple lines within a cell.

Or Choose Shrink to fit reduces character size to fit within a cell.

Or Merge cells combines selected cells into a single cell. Click OK.

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