+ Reply to Thread
Results 1 to 3 of 3

carriage return without wrap text?

  1. #1
    Registered User
    Join Date
    11-29-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    8

    carriage return without wrap text?

    Hello
    Should I be able to force carriage returns using ALT+enter in a cell without wrap text being activated? I *feel* like this was possible in the past, but I might be wrong and it seems impossible now.
    When I use ALT+enter to force a carriage return, Excel applies wrap text to the cell. When I then turn off wrap text, all the carriage returns are ignored.
    I'd like to have text displayed on two lines in a cell and one of these lines will be wider than the column the cell is in (and I don't want to widen the column).
    Thanks
    Excel 2010 / Win7

  2. #2
    Valued Forum Contributor
    Join Date
    03-29-2013
    Location
    United Kingdom
    MS-Off Ver
    Office/Excel 2013
    Posts
    1,749

    Re: carriage return without wrap text?

    Set the row heights to a fixed value....
    Elegant Simplicity............. Not Always

  3. #3
    Registered User
    Join Date
    11-29-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: carriage return without wrap text?

    Thanks, but that doesn't seem to work:

    Capture.JPG

+ 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