ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   vertical text across multiple cells (https://www.excelbanter.com/excel-discussion-misc-queries/58691-vertical-text-across-multiple-cells.html)

BThrasher

vertical text across multiple cells
 
How can I type vertical text across multiple cells. I need to type text from
C2: downward across several cells depending on the length of the word. If I
try it it wants to enlarge the size of C2: to accommodate the text.

bpeltzer

vertical text across multiple cells
 
Highlight the cells across which the text should span. Then on the menu bar:
Format Cells, click the Alignment tab. Select the 'merge cells' checkbox
and, if you want, use the dial to orient the text.

"BThrasher" wrote:

How can I type vertical text across multiple cells. I need to type text from
C2: downward across several cells depending on the length of the word. If I
try it it wants to enlarge the size of C2: to accommodate the text.


BThrasher

vertical text across multiple cells
 
Thanks much and I had just figured that out. But it is a pain in the butt. I
guess I was looking for a simpler solution. Wanting it to work like text in
an horizontal format. It just goes into the next cell with out enlarging the
size of the cell and with out merging the cells. But at this time it may very
well be the only solution. Again thamks so much

"bpeltzer" wrote:

Highlight the cells across which the text should span. Then on the menu bar:
Format Cells, click the Alignment tab. Select the 'merge cells' checkbox
and, if you want, use the dial to orient the text.

"BThrasher" wrote:

How can I type vertical text across multiple cells. I need to type text from
C2: downward across several cells depending on the length of the word. If I
try it it wants to enlarge the size of C2: to accommodate the text.


Therese

vertical text across multiple cells
 
....and then the "formatting-paintbrush" to multiply instead of doing it in
every cell.
--
Therese


"BThrasher" skrev:

Thanks much and I had just figured that out. But it is a pain in the butt. I
guess I was looking for a simpler solution. Wanting it to work like text in
an horizontal format. It just goes into the next cell with out enlarging the
size of the cell and with out merging the cells. But at this time it may very
well be the only solution. Again thamks so much

"bpeltzer" wrote:

Highlight the cells across which the text should span. Then on the menu bar:
Format Cells, click the Alignment tab. Select the 'merge cells' checkbox
and, if you want, use the dial to orient the text.

"BThrasher" wrote:

How can I type vertical text across multiple cells. I need to type text from
C2: downward across several cells depending on the length of the word. If I
try it it wants to enlarge the size of C2: to accommodate the text.



All times are GMT +1. The time now is 08:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com