Show Me Microsoft Office Excel 2003

When you enter data in a cell, Excel aligns labels on the left edge of the cell and aligns values and formulas on the right edge of the cell . Horizontal alignment is the way in which Excel aligns the contents of a cell relative to the left or right edge of the cell; vertical alignment is the way in which Excel aligns cell contents relative to the top and bottom of the cell. Excel also provides an option for changing the flow and angle of characters within a cell. The orientation of the contents of a cell is expressed in degrees. The default orientation is 0 degrees, in which characters are aligned horizontally within a cell.

Change Alignment Using the Format Dialog Box

Select a cell or range containing the data to be realigned.

Click the Format menu, and then click Cells .

Click the Alignment tab.

Click the Horizontal list arrow or the Vertical list arrow, and then select an alignment.

Select an orientation. Click a point on the map, or click the Degrees up or down arrow.

If you want, select one or more of the Text Control check boxes.

Click OK.

Change Alignment Using the Formatting Toolbar

Select a cell or range containing the data to be realigned.

Click the Align Left, Center, or Align Right button on the Formatting toolbar.

To center cell contents across selected columns, click the Merge And Center button on the Formatting toolbar.