Align Data

The alignment functions contain options to configure the position of text within a cell. Use alignment to determine the following:

• The horizontal and vertical alignment of data in selected cells
• The orientation of data in selected cells.
• Whether long cell entries should be wrapped within the cell (Wrap Text).
• Whether text size should shrink to fit the column width (Shrink to Fit).
• If selected cells should be merged to form a single cell (Merge Cells).
• The direction of the text (left to right).

To align data within a cell:

1. Navigate to the Home Tab/Alignment Group.
2. Select the cell(s) to configure.
3. Select the appropriate alignment or click on the arrow in the lower right hand corner for more options (the Format Cells dialog box).

• Click on the Alignment tab.
• Make the appropriate changes from the categories listed on the Alignment tab (right, left, center).
• Click OK.

EXCEL EXTRAS

You can also perform basic data alignment using the icons on the Home Tab/Alignment Group.