+ Reply to Thread
Results 1 to 13 of 13

Why doesn't text wrap in a cell in Excel?

  1. #1
    rohrbaught
    Guest

    Why doesn't text wrap in a cell in Excel?

    I am typing text in a cell and want it to wrap. I checked "wrap text" box
    however it still doesn't wrap and I can only see part of the text. When I
    click on the cell the text is there, but I still can't view it if I'm not in
    that specific cell.

  2. #2
    X_HOBBES
    Guest

    Re: Why doesn't text wrap in a cell in Excel?

    Is your cell high enough? Try making your cell hight a bit taller. Excel
    should automatically adjust the cell height, but that's not always the case.

    X_HOBBES


    "rohrbaught" <[email protected]> wrote in message
    news:[email protected]...
    > I am typing text in a cell and want it to wrap. I checked "wrap text" box
    > however it still doesn't wrap and I can only see part of the text. When I
    > click on the cell the text is there, but I still can't view it if I'm not

    in
    > that specific cell.




  3. #3
    P Sitaram
    Guest

    Re: Why doesn't text wrap in a cell in Excel?

    Move the mouse to the row number on the left and double-clik on the
    bottom border. The row height will auto adjust.


  4. #4
    Amedee Van Gasse
    Guest

    Re: Why doesn't text wrap in a cell in Excel?

    rohrbaught shared this with us in microsoft.public.excel.misc:

    > I am typing text in a cell and want it to wrap. I checked "wrap
    > text" box however it still doesn't wrap and I can only see part of
    > the text. When I click on the cell the text is there, but I still
    > can't view it if I'm not in that specific cell.


    Press ALT+Enter to insert new lines in the same cell.

    --
    Amedee Van Gasse using XanaNews 1.17.3.1
    If it has an "X" in the name, it must be Linux?

    How To Ask Questions The Smart Way
    http://www.catb.org/~esr/faqs/smart-questions.html
    How to Report Bugs Effectively
    http://www.chiark.greenend.org.uk/~sgtatham/bugs.html
    Only ask questions with yes/no answers if you want "yes" or "no" as the
    answer.
    http://homepages.tesco.net/~J.deBoyn...-with-yes-or-n
    o-answers.html

  5. #5
    rohrbaught
    Guest

    Re: Why doesn't text wrap in a cell in Excel?

    You are exactly right...I expanded the height with my cursor and sure enough
    the "hidden" text appeared. Thanks!

    "X_HOBBES" wrote:

    > Is your cell high enough? Try making your cell hight a bit taller. Excel
    > should automatically adjust the cell height, but that's not always the case.
    >
    > X_HOBBES
    >
    >
    > "rohrbaught" <[email protected]> wrote in message
    > news:[email protected]...
    > > I am typing text in a cell and want it to wrap. I checked "wrap text" box
    > > however it still doesn't wrap and I can only see part of the text. When I
    > > click on the cell the text is there, but I still can't view it if I'm not

    > in
    > > that specific cell.

    >
    >
    >


  6. #6
    rohrbaught
    Guest

    Re: Why doesn't text wrap in a cell in Excel?

    Sorry, I wasn't able to follow your instructions.

    "P Sitaram" wrote:

    > Move the mouse to the row number on the left and double-clik on the
    > bottom border. The row height will auto adjust.
    >
    >


  7. #7
    rohrbaught
    Guest

    Re: Why doesn't text wrap in a cell in Excel?

    Thanks for responding...I tried this and did not work.

    "Amedee Van Gasse" wrote:

    > rohrbaught shared this with us in microsoft.public.excel.misc:
    >
    > > I am typing text in a cell and want it to wrap. I checked "wrap
    > > text" box however it still doesn't wrap and I can only see part of
    > > the text. When I click on the cell the text is there, but I still
    > > can't view it if I'm not in that specific cell.

    >
    > Press ALT+Enter to insert new lines in the same cell.
    >
    > --
    > Amedee Van Gasse using XanaNews 1.17.3.1
    > If it has an "X" in the name, it must be Linux?
    >
    > How To Ask Questions The Smart Way
    > http://www.catb.org/~esr/faqs/smart-questions.html
    > How to Report Bugs Effectively
    > http://www.chiark.greenend.org.uk/~sgtatham/bugs.html
    > Only ask questions with yes/no answers if you want "yes" or "no" as the
    > answer.
    > http://homepages.tesco.net/~J.deBoyn...-with-yes-or-n
    > o-answers.html
    >


  8. #8
    Amedee Van Gasse
    Guest

    Re: Why doesn't text wrap in a cell in Excel?

    rohrbaught shared this with us in microsoft.public.excel.misc:

    > Thanks for responding...I tried this and did not work.


    I'm sorry to hear that. It works for me.
    Please note that this does not make the line wrap, it just adds hard
    coded line breaks. Please follow Hobbes' instructions.

    --
    Amedee Van Gasse using XanaNews 1.17.3.1
    If it has an "X" in the name, it must be Linux?

    How To Ask Questions The Smart Way
    http://www.catb.org/~esr/faqs/smart-questions.html
    How to Report Bugs Effectively
    http://www.chiark.greenend.org.uk/~sgtatham/bugs.html
    Only ask questions with yes/no answers if you want "yes" or "no" as the
    answer.
    http://homepages.tesco.net/~J.deBoyn...-with-yes-or-n
    o-answers.html

  9. #9
    Rivky
    Guest

    Re: Why doesn't text wrap in a cell in Excel?

    You also need to make sure your cell is set to wrap. Right click on
    cell. Click format. Alignment tab. Check "Wrap Text"


  10. #10
    Registered User
    Join Date
    04-19-2005
    Posts
    1

    Smile Merged cells cause the problem...

    ...try putting a single cell to the right (of width equal to the sum of all the merged cells with the wrap problem and with word wrap ticked - best to format the same).

    Then make this cell equal the merged cell (e.g. "=C3").

    The autofit should now work.

  11. #11
    Registered User
    Join Date
    08-09-2016
    Location
    Paris
    MS-Off Ver
    2016
    Posts
    1

    Re: Why doesn't text wrap in a cell in Excel?

    I had similar problem. I had a table with many columns and rows with text. Wrap text option didn't work but I wanted to print directly from Excel.
    My solution was this. I selected whole column and clicked Wrap text button and it WORKED. I tried to select more columns at same time and it WORKED. When I select whole table it didn't work.

  12. #12
    Registered User
    Join Date
    12-31-2017
    Location
    BOSTON
    MS-Off Ver
    2010
    Posts
    1

    Re: Why doesn't text wrap in a cell in Excel?

    I tried all of the suggested fixes and none worked for me. My worksheet had data that was converted from a pdf spreadsheet. It had cells that been merged, then unmerged and text Concantonated, date times split to date column and time columns, etc.
    I even had some cells in a column where the text would center ok and the in the next row the text would not center no matter what formatting I tried.
    The only thing that ended up working was to:
    1) Save the sheet as a comma delineated file.
    2) Close it.
    3) Open it.
    It now has all the data back in default formatting - no wrapping, not autofit.

    I was then able to select columns and set Word Wrap. Select other columns and select Autofit. Select the entire worksheet and Autofit rows. Change fonts and font sizes.

  13. #13
    Registered User
    Join Date
    11-11-2018
    Location
    Miami, FL
    MS-Off Ver
    Excel for MAC, version 16.18
    Posts
    1

    Re: Why doesn't text wrap in a cell in Excel?

    I had the same problem. First, select the all the cells you're having the issue with. Then click Home tab. Then click Format tab. Then select row, then autofit.
    This worked for me. Now all the rows show the wrapped text.

+ 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