vertical text across multiple cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
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
 
....and then the "formatting-paintbrush" to multiply instead of doing it in
every cell.
 

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

Similar Threads

counting text same cell multiple worksheets 11
referencing multiple cells when data is organised differently 1
entering text 2
Formatting Text in one cell Vertically 3
I need to add multiple cells then subtract them from one cell c4+c6+c7+c9+c10+c11 and subtract them 1
3 numbers in each cell aligned verticaly one number in each cell 1
Cell Reference Generation 2
'Centre across selection' format to apply to vertical range 3

Back
Top