W
Will
The following Help data is under the Help topic "Position
data in a cell" in Microsoft Excel 2002. I do not have
the feature (Bottom (Indent) & Top (Indent))available
under Format -> Cells. on the menu bar though. What can I
do?
Position data in a cell
Select the cells you want to reposition. To center or
align data that spans several columns or rows, such as
column and row labels, first merge a selected range of
cells and then select the merged cell for repositioning.
Do one of the following:
Center, left-align, or right-align data
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.
Tip
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.
Increase or decrease indented text from the left edge of a
cell
On the Formatting toolbar, click Increase Indent or
Decrease Indent .
Indent text 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 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.
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.
Rotate text in a cell
On the Format menu, click Cells, and then click the
Alignment tab.
In the Orientation box, click a degree point, or drag the
indicator to the angle you want.
To display text vertically from top to bottom, click the
vertical Text box under Orientation.
data in a cell" in Microsoft Excel 2002. I do not have
the feature (Bottom (Indent) & Top (Indent))available
under Format -> Cells. on the menu bar though. What can I
do?
Position data in a cell
Select the cells you want to reposition. To center or
align data that spans several columns or rows, such as
column and row labels, first merge a selected range of
cells and then select the merged cell for repositioning.
Do one of the following:
Center, left-align, or right-align data
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.
Tip
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.
Increase or decrease indented text from the left edge of a
cell
On the Formatting toolbar, click Increase Indent or
Decrease Indent .
Indent text 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 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.
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.
Rotate text in a cell
On the Format menu, click Cells, and then click the
Alignment tab.
In the Orientation box, click a degree point, or drag the
indicator to the angle you want.
To display text vertically from top to bottom, click the
vertical Text box under Orientation.