Aligning Data in Cells

The Alignment tab in the Format Cells dialog box, as shown in Figure 8-17, positions text and numbers in cells. It also contains options you can use to create multiline text labels, repeat a series of characters within one or more cells, and orient text vertically or at any angle in cells. The Alignment tab includes the following options:

  • Horizontal. These options control the right or left alignment within the cell. The General option, the default for Horizontal alignment, right aligns numeric values and left aligns text values.

  • Vertical. These options control the top-to-bottom position of cell contents within cells.

  • Orientation. These controls align text at virtually any angle within a cell.

  • Text Control. These three options ...

Get Microsoft® Office Excel 2003 Inside Out now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.