Position data in a cell

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.
 
W

Will

Nope.
-----Original Message-----
Is your sheet protected?

Btw, no need to paste whole help sections when asking a question,
you might as well refer to the help topics name etc..

--

Regards,

Peo Sjoblom





.
 
W

Will

Is there a way to define a default row height like you can
define default column width?
 
D

Dave Peterson

I don't think so, but once you set a rowheight manually, it'll stick until you
autofit it.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top