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

·         Select the cell(s) you wish to align.

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

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

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

To align data between the top and bottom of a cell

·         Select the cell(s) you wish to align.  From the Format menu, select Cells to display the Format Cells dialog box.

·         To view the Alignment options, click on the Alignment tab at the top of the dialog box.

·         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, choose the Justify option.

·         Click on OK .

To change the “read” orientation of data in cells

·         Select the cell(s) you wish to change and from the Format menu, choose Cells or press Ctrl+1 , to display the Format Cells dialog box.

·         To view the Alignment options, click on the Alignment tab at the top of the Format Cells dialog box.

·         Click the option you require in the Orientation area.

·         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(s) you wish to format.

·         From the Format menu, choose Cells or press Ctrl+1 to display the Format Cells dialog box.

·         Click on the Alignment tab to display the Alignment options.

·         Select the Wrap text check box and click on OK .

To indent data within a cell

·       First select the cell(s) that you wish to apply the indenting formatting to.

·       Right click to display the pop-up box, and from the list displayed, select Format Cells .   This will display the Format Cells dialog box.  Select the Alignment tab.

·       Select Left (Indent) from the Text alignment / Horizontal list, and then use the spinner controls to add the required indent.

·       Select OK .

To rotate text to any angle

·       First select the cell(s) that you wish to apply the rotation formatting to.

·       Right click to display the pop-up box, and from the list displayed, select Format Cells .   This will display the Format Cells dialog box.  Select the Alignment tab.

·       From the Orientation section either enter the exact amount of rotation required into the Degrees box, or drag the Text dial to give the desired level of rotation.

·       Select OK .

To center a heading over multiple columns

·         Type a heading at the top of the left-hand column.

·         Place the cell pointer on the heading cell and highlight it along with all the cells across the columns.

·         On the Formatting toolbar, click the Merge and Center icon.

To center data within a cell

·         Highlight the cell(s) which contain the data you wish to center.

·         On the Formatting toolbar, click the Center icon to center the data within the cell(s).