Changing Data Alignment

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 character flow and rotation of text in a cell. You can select the rotate text in horizontal orientation up or down. The default orientation is 0 degrees ”the text is level in a cell .

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.

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 Text Control check boxes.

Click OK.