Aligning data
You can align data horizontally and vertically in a cell. The default alignment setting for numbers and formula results is right-aligned; the default setting for labels and dates is left-aligned. You can change the default alignment of all labels.
You can also center data across multiple cells; for example, you can center a title across columns C, D, and E. You can also change the orientation of text in a cell by rotating it horizontally, vertically, or by a specific degree.
To align data in a cell |  |
|
1.
|
|
Select a cell.
|
|
2.
|
|
Click Format
 Selection properties. |
|
3.
|
|
Click the Alignment tab.
|
|
4.
|
|
In the Horizontal alignment area, enable one of the following options:
|
|
•
|
General — right-aligns values and left-aligns labels
|
|
•
|
Left — left-aligns all types of data
|
|
•
|
Right — right-aligns all types of data
|
|
•
|
Center — centers cell data
|
|
•
|
Indent — moves data in from the edge of a cell. Type a value to specify the amount by which you want to indent the cell content.
|
|
5.
|
|
In the Vertical alignment area, enable one of the following options:
|
|
•
|
Top
|
|
•
|
Center
|
|
•
|
Bottom
|
|
•
|
|
You can also click the Alignment
 button on the property bar to change horizontal cell alignment. |
To set the default alignment for all labels | |
|
1.
|
|
Click Format
Define styles. |
|
2.
|
|
Choose Normal from the Define style for list box.
|
|
3.
|
|
Click Alignment.
|
|
4.
|
|
In the Alignment dialog box, modify the alignment settings.
|
To center text across multiple cells | |
|
1.
|
|
In the left-most cell, type the text to be centered.
|
|
2.
|
|
Select the cells over which
to center the text starting with the cell containing the text. |
|
3.
|
|
Click Format
Selection properties. |
|
4.
|
|
Click the Alignment tab.
|
|
5.
|
|
In the Horizontal alignment area, enable the Center across block option.
|
|
•
|
|
If you type text in a second cell where text is centered across cells, the first entry is centered over cells to the left of the next entry.
|
|
•
|
|
To display the centered text in the input line, click the cell where the text was originally entered.
|
To rotate text | |
|
1.
|
|
Click a cell with text to rotate.
|
|
2.
|
|
Click Format
Selection properties. |
|
3.
|
|
Click the Alignment tab.
|
|
4.
|
|
In the Orientation area, enable one of the following options:
|
|
•
|
Horizontal — orients text horizontally
|
|
•
|
Vertical — orients text vertically
|
|
•
|
Rotated — rotates text to the degree you specify
|
|
•
|
|
If you enable the Rotated option, specifying 90 or -90 rotates the text vertically.
|