To change the horizontal and vertical text alignment:
Select the cell(s) that you want to format.
Go to the Format menu, and click Cells.
Click the Alignment tab.
Here, you can:
Select a horizontal alignment from the Horizontal box:
General: Text will be aligned according to its type (e.g., numbers are aligned to the right, while currency and labels are aligned to the left).
Left: Standard left text alignment.
Center: Standard centered text alignment.
Right: Standard right text alignment.
Fill: Data will fill the entire width of the cell. If the cell contains a number value, the number will be repeated so that it fills the cell.
Center Across Cells: Data will be centered across the entire width of the column(s) selected.
Select a vertical alignment from the Vertical box:
Top: Text will be pushed to the top of the cell.
Center: Text will be centered in the cell.
Bottom: Text will be pushed to the bottom of the cell.
If you do not want text from one cell to overflow into another (or become truncated if the adjacent cell already contains a value), check off Wrap Text.
When you are finished, click OK.
The alignment formatting will be applied to the selected cell(s).
Note: To quickly access the alignment settings window, go to the Format menu, and click Centering.
Changing Horizontal Alignment in Advanced Mode
To change the horizontal text alignment in Advanced Mode:
Select the cell(s) that you want to format.