align text??
 

Winxp(home) Office(excel) 2k.

Is there a way to align text vertically in a cell?
Under format cell and alignment tab, I can align Right and then Justify but
I need more control.
Ex: This is a test.

I can get;
This This is
is a or a test.
test.

but need;
This
is
a
test.

Any way to do this?

align text??
 

Precede a word with Alt-Enter to force it to the next line. HTH Otto
"L.S." wrote in message
...
Winxp(home) Office(excel) 2k.

Is there a way to align text vertically in a cell?
Under format cell and alignment tab, I can align Right and then Justify
but I need more control.
Ex: This is a test.

I can get;
This This is
is a or a test.
test.

but need;
This
is
a
test.

Any way to do this?

align text??
 

Hi,

go back to the Alignment tab of the Format Cells dialog box and look on the
right side of the window. There are a number of options for alignining
vertically. There is also a vertical align in the drop down below Horizontal
on that page. Further you can use word wrap in some cases.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"L.S." wrote:

Winxp(home) Office(excel) 2k.

Is there a way to align text vertically in a cell?
Under format cell and alignment tab, I can align Right and then Justify but
I need more control.
Ex: This is a test.

I can get;
This This is
is a or a test.
test.

but need;
This
is
a
test.

Any way to do this?

align text??
 

thanks, got it.

"Otto Moehrbach" wrote in message
...

Precede a word with Alt-Enter to force it to the next line.

HTH Otto
"L.S." wrote in message
...
Winxp(home) Office(excel) 2k.

Is there a way to align text vertically in a cell?
Under format cell and alignment tab, I can align Right and then Justify
but I need more control.
Ex: This is a test.

I can get;
This This is
is a or a test.
test.

but need;
This
is
a
test.

Any way to do this?