Select the cells in which you want to align the data to the left, and click the Align Left button on the Formatting toolbar.
Select the cells in which you want to align the data to the right, and click the Align Right button.
Select the cells in which you want to center the data, and click the Center button.
The alignments are applied to the selected cells.
INTRODUCTION
The most common alignment changes you'll make are probably to center data in a cell, align data with a cell's right edge (right-align), or align data with a cell's left edge (left-align). The default alignment for numbers is right-aligned; the default alignment for text is left-aligned.
TIP
More Alignment Options
If you want more alignment options than are readily available on the Formatting toolbar, open the Format menu, select Cells, and click the Alignment tab in the dialog box that appears. In the Horizontal drop-down list, scroll through the additional options available to you. If, after you select data to align, you click the same alignment toolbar button a second time, the cell returns to its default alignment.