| |
|
Q) How do I align (position) data in a cell?
A) To center or align data in a cell:
- Select the cells in which you want to reposition the data. To center or align data that goes across several columns or rows, (such as column and row labels), first highlight the selected range of cells.
- Do one of the following:
On the Formatting toolbar, click the appropriate button.
- Click Align Left, to align text to the left.
- Click Center, to center text.
- Click Align Right, to align text to the right.
To restore the default alignment, select the cells, click Cells on the Format menu, and then click the Alignment tab. In the Horizontal box, click General.
A) To indent data in a cell:
- On the Format menu, click Cells, and then click the Alignment tab.
- Do one of the following:
- To indent text from the left, right, or both sides of the cell, in the Horizontal box, click Left (Indent), Right (Indent), or Distributed (Indent). Then, in the Indent box, click the amount of indent you want.
- To indent text from the top, bottom, or both top and bottom of the cell, in the Vertical box, click Top (Indent), Bottom (Indent), or Distributed. Then, in the Indent box, click the amount of indent you want.
- To horizontally justify text that is distributed in a cell (indented or centered from both sides), in the Horizontal box, click Justify.
- To horizontally justify text that is not distributed in a cell, in the Horizontal box, click Distributed (Indent), and then click Justify distributed.
- To vertically justify text in a cell, in the Vertical box, click Justify.
A) To align data at the top, center or bottom of a cell:
- On the Format menu, click Cells, and then click the Alignment tab.
- In the Vertical box, click the option you want.
|
|
|