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 books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.