If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do you stack 3 words in one cell
I am trying to figure out how to put the text "monthly rental pmnts" all in
one cell so that they stack on top of each other. Any suggestions? |
#2
|
|||
|
|||
How do you stack 3 words in one cell
Hi
Format the cell textWrapped Then use Alt+Enter after each value where you want to start a new line -- ------- Regards Roger Govier "Tami Sawyer" Tami wrote in message ... I am trying to figure out how to put the text "monthly rental pmnts" all in one cell so that they stack on top of each other. Any suggestions? __________ Information from ESET Smart Security, version of virus signature database 5164 (20100601) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 5164 (20100601) __________ The message was checked by ESET Smart Security. http://www.eset.com |
#3
|
|||
|
|||
How do you stack 3 words in one cell
|
#4
|
|||
|
|||
How do you stack 3 words in one cell
You can use alt-enter:
A word(alt-enter)A second word(alt-enter)A Third word would look like: A word A second word A Third word And if you're using a formula: =a1&char(10)&b1&char(10)&c1 And format the cell to wraptext Tami Sawyer wrote: I am trying to figure out how to put the text "monthly rental pmnts" all in one cell so that they stack on top of each other. Any suggestions? -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|