Setting Worksheet Alignment

[ LiB ]

By default, Excel makes labels left-aligned and values rightaligned to their cells . You can change the alignment of either to left, right, centered, or full justified.

You can also wrap text in the cells when the text is too long to fit in one cell and you don't want it to overlap to the next cell.

Adjusting Cell Alignment

You can adjust cells individually or adjust a block of cells.

NOTE

The Wrap text feature treats each cell like a miniature word processor, with text wrapping around in the cell.

Setting Vertical Alignment

Excel aligns text vertically to the bottom of the row, but you can also center it or align it to the top of the cell. You can also make the entire cell contents display vertically or at an angle.

Centering Headings

You can also center text across a group of columns to create attractive headings.

NOTE

In this example, it appears that the heading is located in Columns B, C, and D; however, the text is still in Column A. If you need to change the text, be sure to select Column A, not Column B, C, or D.

[ LiB ]