row height when entering vertical text ?

SparQ2020

New Member
Joined
Nov 6, 2002
Messages
3
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
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

SparQ2020

New Member
Joined
Nov 6, 2002
Messages
3
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

Well-known Member
Joined
Feb 16, 2002
Messages
761
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

Board Regular
Joined
Aug 18, 2002
Messages
102
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

New Member
Joined
Nov 6, 2002
Messages
3
Thanks to All !!!

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

Forum statistics

Threads
1,143,615
Messages
5,719,725
Members
422,242
Latest member
hishamkhatri

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top