row height when entering vertical text ?

[SparQ2020]

When you enter text horizontal the text spans several columns
How can you get text to do the same when entering it vertical ?

Thanks for any info

 

[maxflia10]

Alt + Enter or under Format/Cells/Alignment, check off text wrap

 

[SparQ2020]

thanks
word wrap is off
what i'm looking for is how to keep the row height at 12.75 and the text span down across several rows
like it does when you enter text horizontal and it spans across several columns
This message was edited by SparQ2020 on 2002-11-07 22:36

 

[RichardS]

The only thing I can think of to do is change the row size back to 15, then highlight a selection of vertical cells and merge them. Probably not what you want.

Richard

 

[Alriemer]

Solution I use for this is a text box with no fill or borders. Hold down ALT while sizing the box to snap to the grid. You could put a text box over several rows and format it with one of the vertical alignments.

This is not as limiting as it seems: you can make text box contents dynamic. For this, make a cell somewhere that contains whatever content you want to appear in the text box (result of INDEX, CONCATENATE, TEXT, etc). Select the tet box - click directly on the border so it is solid grey. Then click in the formula bar and type the address of your cell (ie =$A$1) and hit Enter. Then format.

Hope this helps
Alriemer

EDIT - Sparq, welcome to the board. I gotta take off but back tomorrow if necessary.
This message was edited by Alriemer on 2002-11-08 00:35
This message was edited by Alriemer on 2002-11-08 00:36

 

[SparQ2020]

Thanks to All !!!

The text box seems to be what i need
(Now if i can get it to work with everything else) ô¿ô
0