How do you stack 3 words in one cell

T

Tami Sawyer

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?
 
R

Roger Govier

Hi
Format the cell text>Wrapped
Then use Alt+Enter after each value where you want to start a new line

--
-------
Regards
Roger Govier

Tami Sawyer said:
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
 
L

Lars-Åke Aspelin

On Tue, 1 Jun 2010 13:57:01 -0700, Tami Sawyer <Tami
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?

Push ALT+ENTER wherever you want a new line

Hope this helps / Lars-Åke
 
D

Dave Peterson

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
 

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

Top