Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Oct 2003
    Location
    South-Western, Ontario, Canada
    Posts
    41
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Use of Enter key (Excel 2007)

    Subject edited by HansV to be slightly more descriptive than just 'Excel'

    Hi 'helpers'
    Have the above installed without help textbook at hand. Here's the situation:
    I have merged multiple cells on a quotation template in order to key specific information for a customer. However,
    when I hit 'enter' it automatically jumps out of the merged cell area and goes to the adjacent cell below. I understand
    this logic but cannot (even with the help of "HELP") figure it out. The 'backspace', and all the 'arrow' keys are
    functioning as they should within this merge, but the 'ENTER' key??????????................Help, I'm in the middle of
    a quote. Thanks folks.
    Jason

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Use of Enter key (Excel 2007)

    Select the merged cell.
    On the Home tab of the Ribbon, in the Alignment section, click Wrap Text. This will allow multi-line entries.
    The user will have to press Alt+Enter to start a new line within the cell.

  3. #3
    Lounger
    Join Date
    Oct 2003
    Location
    South-Western, Ontario, Canada
    Posts
    41
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Use of Enter key (Excel 2007)

    Hans,

    Many thanks,
    My problem in this area at least has been solved; it was that 'Alt+Enter' that I didn't have.
    Jason

Posting Permissions

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