+ Reply to Thread
Results 1 to 5 of 5

How do I put several words one on top the other in one cell?

  1. #1
    mark1000000
    Guest

    How do I put several words one on top the other in one cell?

    I guess, in other words what I'm looking for is if I wanted to write a
    paragraph and place that entire paragraph in one cell. But, I want to be
    able to see the entire paragraph in that one cell even after I place
    information in the cell to the right of it. I do know how to size the
    individual cell to accommodate the size of paragraph I want. It’s got to be
    easy but I just haven’t figured out where to click. – Thanks for your kind
    help – mark1000000

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,525
    try out insert coment,
    right click on the cell and select, insert comment, you can adjust the size of the comment box accordingly,
    if that won't work for you you could always use a textbox,
    in the drawings toolbar select textbox, you can place the textbox wherever you require,
    to add extra lines to a cell, hit Alt-Enter, this will give you another line in the cell,

  3. #3
    Valued Forum Contributor tony h's Avatar
    Join Date
    03-14-2005
    Location
    England: London and Lincolnshire
    Posts
    1,187
    either use the cell format format...cell...alignment...wordwrap

    or use alt-enter to split the cell text into paragraphs

    hope this helps

  4. #4
    James Hamilton
    Guest

    RE: How do I put several words one on top the other in one cell?

    Type the text in the cell.

    Then right-click -> Format Cells -> Alignment -> Click on the "Wrap Text" box.

    That should work.

    "mark1000000" wrote:

    > I guess, in other words what I'm looking for is if I wanted to write a
    > paragraph and place that entire paragraph in one cell. But, I want to be
    > able to see the entire paragraph in that one cell even after I place
    > information in the cell to the right of it. I do know how to size the
    > individual cell to accommodate the size of paragraph I want. It’s got to be
    > easy but I just haven’t figured out where to click. – Thanks for your kind
    > help – mark1000000


  5. #5
    mark1000000
    Guest

    RE: How do I put several words one on top the other in one cell?

    The answer came back within 5 minutes.
    James Hamilton and tony h had just what I was looking for I thank you very
    much for that. And thank you too davesexcel for your speedy response. I
    really can't believe how quick you came back with answers thanks a mill.

    Now dumb me found the answer before I came back here. I should have done
    this in the first place, but didn't. The reason I didn't is because I
    thought there would be to many entries. At any rate, here's want I did.
    When in Excel I pressed F1 for help, typed in "cell" enter. Went done the
    list of 30 results, clicked on "Wrap text in a cell". And there was the
    answer everyone gave me. I know kind of dumb that I didn't figure the simple
    process out before on how to find answers on my own. - Thanks everybody for
    your quick responses - mark1000000


    "James Hamilton" wrote:

    > Type the text in the cell.
    >
    > Then right-click -> Format Cells -> Alignment -> Click on the "Wrap Text" box.
    >
    > That should work.
    >
    > "mark1000000" wrote:
    >
    > > I guess, in other words what I'm looking for is if I wanted to write a
    > > paragraph and place that entire paragraph in one cell. But, I want to be
    > > able to see the entire paragraph in that one cell even after I place
    > > information in the cell to the right of it. I do know how to size the
    > > individual cell to accommodate the size of paragraph I want. It’s got to be
    > > easy but I just haven’t figured out where to click. – Thanks for your kind
    > > help – mark1000000


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1