The Excel Formatting - Alignment

To align data between the left and right sides of a cell

· Select the cell, or cells, you wish to align.

· On the Excel Formatting toolbar, click on the Align Left icon to align data with the left edge of the cell.

· Click on the Align Right icon to align data with the right edge of the cell.

· Click on the Center icon to center data in the cell.

To align data between the top and bottom of a cell

· Select the cell, or cells, you wish to align.

· From the Format menu, click Cells.

· From the Format Cells dialog box displayed, click on the Alignment tab.

· In the Text alignment section, choose the Top, Center, or Bottom option in the Vertical area to align the data in the cell.

· To make the lines of data fit evenly within the height of a cell, tick the Justify distributed option and click on OK.

To change the orientation of data cells

· Select the cell, or cells, you wish to change.

· From the Format menu, click Cells.

· From the Format Cells dialog box displayed, click on the Alignment tab.

· In the Orientation section, you can change the Degrees of the text or use the mouse to drag the 'red small diamond' up or down. When satisfied, click on OK.

To wrap multiple lines of data in a cell

· Type the data you require into the cell and press Enter. The entry will appear as one long line and select the cell, or cells, you wish to format.

· From the Format menu, click Cells.

· From the Format Cells dialog box displayed, click on the Alignment tab.

· In the Text control section, tick the Wrap text check box and click on OK.

To shrink the text into one cell

· Type the data you require into the cell and press Enter.

· From the Format menu, click Cells.

· From the Format Cells dialog box displayed, click on the Alignment tab.

· In the Text control section, tick the Shrink to fit check box and click on OK.

To merge several cells

· Select the cells that you wish to merge to become one cell.

· Right-click on the selected cells, click Format Cells.

· From the Format Cells dialog box displayed, click on the Alignment tab.

· In the Text control section, tick the Merge cells check box and click on OK.
Note: You also can use the Merge and Center icon on the Excel Formatting toolbar