Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

Wrapping Text in a Text Box

Latest post Fri, Aug 6 2010 1:22 PM by Omar. 3 replies.
  • Wed, Aug 4 2010 1:15 PM

    • Viper
    • Not Ranked
    • Joined on Wed, Aug 4 2010
    • Posts 2
    • Points 42

    Paradise [ip] Wrapping Text in a Text Box

    Hi Everyone,

     

    I am an average Excel user using 2007.  I am trying to type text in a text box such that I place text in the the 1st line, skip a few lines by hitting the <ENTER> key, then add my next line of text.  The problem is when I hit the <ENTER> key, nothing happens.  Also, if I hit the <SPACE BAR> continuously, the cursor moves to the right continuously, extending well beyond the border of the text box and it never wraps back to create a 2nd line in the text box.  

    I have seen this problem posted in other forums in other versions of Excel with the advice to "set Enterkeybehavior and Multiline Property = TRUE".  I have no idea what all that means or how to do it.  Don't know if that is what's necessary here.

    Please help. 

    • Post Points: 21
  • Wed, Aug 4 2010 1:32 PM In reply to

    • Omar
    • Top 10 Contributor
    • Joined on Sat, Jan 12 2008
    • Kitchener, ON
    • Posts 128
    • Points 1,823

    Re: Wrapping Text in a Text Box

    In Design mode (click on the Developer/Controls Group/Design Mode button), right click the text box. Choose Properties. Find "EnterKeyBehavior" and set it to True. Do the same for "MultiLine" to set it to True.

    Click on the Design Mode button to set the text box back to active status.

    Omar Freeman Kitchener, ON

    • Post Points: 21
  • Fri, Aug 6 2010 12:03 PM In reply to

    • Viper
    • Not Ranked
    • Joined on Wed, Aug 4 2010
    • Posts 2
    • Points 42

    Re: Wrapping Text in a Text Box

    Omar,
    Thank you so much for your response.  I have looked everywhere trying to find the Developer/Controls Group/Design Mode button you refer to and do not see it.  Can you provide a little more specific detail on where that is?
    Thanks  

    • Post Points: 21
  • Fri, Aug 6 2010 1:22 PM In reply to

    • Omar
    • Top 10 Contributor
    • Joined on Sat, Jan 12 2008
    • Kitchener, ON
    • Posts 128
    • Points 1,823

    Re: Wrapping Text in a Text Box

    I was afraid of that. By default in 2007, the Developer tab is hidden. Go to the Office button, then Excel Options. On the Popular tab, check "show Developer tab in the Ribbon".

    Omar Freeman Kitchener, ON

    • Post Points: 5
Page 1 of 1 (4 items) | RSS
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.