Results 1 to 10 of 10

Turning off automatic text-wrapping

This is a discussion on Turning off automatic text-wrapping within the Excel Questions forums, part of the Question Forums category; Does anyone know how to stop Excel from automatically wrapping text? (I have Excel 2000) Even if I have the ...

  1. #1
    New Member
    Join Date
    Oct 2003
    Posts
    11

    Default Turning off automatic text-wrapping

    Does anyone know how to stop Excel from automatically wrapping text? (I have Excel 2000) Even if I have the "Wrap Text" checkbox unchecked for a cell, it will revert to the wrapped text mode every time I type too many characters in that cell. It seems to assume that I want it to wrap text, when in fact I don't. I can always go back and uncheck the "Wrap Text" box after it applies it automatically, but it is getting tiresome since I frequently type a lot of text in cells. Is there some way to turn this off? Thanks.

  2. #2
    MrExcel MVP
    Moderator
    Andrew Poulsom's Avatar
    Join Date
    Jul 2002
    Posts
    69,311

    Default Re: Turning off automatic text-wrapping

    The only way I have been able to replicate that behaviour is if Normal Style has Alignment set to Wrap. Check it out - Format|Style.

  3. #3
    New Member
    Join Date
    Oct 2003
    Posts
    11

    Default Re: Turning off automatic text-wrapping

    Okay, I realized something. This is only happening when the text I put in the cell has returns in it. When there are no returns it does not wrap. When there are returns, it automatically will turn on the wrap and I can't find a way to stop it. I can undo the wrap, but I cannot stop the automatic formatting. I tend to put a lot of text in cells (i.e. paragraphs) as I use Excel as a database and have one field where I store comments.

    So I guess my question is now two-fold: first, is there a way to avoid automatic text wrapping when I have returns in the text of a cell, and second, is there a better way for me to be storing large amounts of text in cells when I am using Excel as a database?

  4. #4
    New Member
    Join Date
    Mar 2005
    Posts
    2

    Default Wrapped Text reverts to unwrapped or visa versa

    I am having the same proplem with wrapped text. In my workbook I have one sheet in which cells do not revert back to wrapped when I double click on them and another sheet in which they do. New sheet always do revert to wrapped. I also have found that if I strip special characters from the text, (not necessarily carriage returns) it will not revert but that is too much work for the amount of copying I do.

    I have another workbook with the opposite issue. I want cells to wrap when I copy data into them. Some do and some don't . I have found no way to perminantly changed the cells to always wrap.. The cells I copy from are all wrapped.

    I hope someone has a solution to this. It's driving me nuts.
    Tim

  5. #5
    New Member
    Join Date
    Mar 2005
    Posts
    2

    Default Turning off automatic text-wrapping

    Correction to my previous post. I am indeed having same issue exactly as described by AXIUM. The reverse issue that I also am having is a little different but just as peplexing.

    For the reverse issue, I was thinking of a similar problem wherein if I enter data into certain cells , the line entered into refuses to expand to fit the wrapping. However, the line can be manually expanded to reveal the entire cell contents. Other lines in the same sheet automatically expand. So far I have found no solution to either issue other than creating a new workbook from scratch.

    One of the spreadsheets was adapted from an older version. Possibly both. This may have been a contributing factor.

    Still searching for an answer, vibes.

  6. #6
    New Member
    Join Date
    Sep 2010
    Posts
    1

    Default Re: Turning off automatic text-wrapping

    The best way that I can find to stop auto-wrapping is to highlight all the cells in sheet and then:
    right click on any number in the row section -> click on height and ok

    I think this works in older versions of excel as well as 2007. The only problem is that if you do then want a cell to wrap you have to check wrap in the formats and double click in between two cells (i.e. the way you normally resize a cell).

    Another way if it's just a one of, is to delete the line gaps in the text (i.e. where return has been hit).

  7. #7
    New Member
    Join Date
    Feb 2011
    Posts
    1

    Default Re: Turning off automatic text-wrapping

    Hi, This problem had been bugging me too. This solved it. As a previous post said "The best way that I can find to stop auto-wrapping is to highlight all the cells in sheet and then: right click on any number in the row section -> click on height and ok, but the kicker is to then format the cells, vertical, TOP. Problem solved!

  8. #8
    New Member
    Join Date
    Sep 2011
    Posts
    3

    Default Re: Turning off automatic text-wrapping

    Yay it worked.

    I guess if you give Excel a set height the cells should be at then it won't set one automatically for you.

  9. #9
    New Member
    Join Date
    Nov 2011
    Posts
    1

    Default Counting number of rows in excel using autowrap in VC++

    Can anybody help me in finding out how i will get used rows in excel.
    I am using AutoWrap() Method in VC++.

  10. #10
    New Member
    Join Date
    Sep 2011
    Posts
    3

    Default Re: Turning off automatic text-wrapping

    On this completely separate issue, you can record a macro and hit CTRL+End. This brings you to the last used row and column in the sheet.
    Be careful though, if you add text to a cell but then delete the cell, the row still counts as being used.

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com