Format Cells dialog - Alignment tab
You use Alignment tab of the Format Cells dialog to specify the way in which text is aligned in the selected cells in the spreadsheet and to specify whether text strings that are longer than the width of a cell should wrap around.
How to access the Format Cells dialog
To access the Format Cells dialog, on the Home tab, click the dialog launcher 
in the Font group.
Explanation of the fields on the dialog
| Field | Description |
|---|---|
| Default | Click this radio button to use the alignment as specified on the Table Definition Properties dialog. |
| Left aligned | Click this radio button to align the text in the selected cells to the left. |
| Centre | Click this radio button to align the text in the selected cells to the centre. |
| Right aligned | Click this radio button to align the text in the selected cells to the right. |
| Word-wrap |
Select this check box to allow text in the selected cells to wrap around onto multiple lines, or clear the check box to display the text as one continuous line, which might be truncated.
When you choose to word-wrap text, the height of spreadsheet rows is adjusted automatically so that all of the text in a cell is visible. If you do not want the height of spreadsheet rows to change in this way, clear the Auto-size rows when word-wrapping check box on the Vertical Scale tab of the Format Bar Chart dialog. |
How do I...
... specify the way in which text is aligned in the selected cells?
Click the appropriate radio button in the Horizontal group.
... specify whether text strings should wrap around if they are longer than the width of a cell?
Select the Word-wrap check box to specify that text strings should wrap around, ensuring that all of the text is visible, or clear the check box to specify that they should not.