how do i form 2 lines in 1 row?

Discussion in 'Microsoft Excel New Users' started by Guest, Jun 4, 2007.

  1. Guest

    Guest Guest

     
    Guest, Jun 4, 2007
    #1
    1. Advertisements

  2. Guest

    Ron Coderre Guest

    I'm guessing you're looking to force text in a cell to wrap into the next
    line of the same cell.

    If that's true......
    Edit the text and move the insertion point to where you want to wrap the
    text.
    Hold down the [Alt] key and press [Enter]

    Does that help?
    ----------------------------------

    Regards,

    Ron
    Microsoft MVP (Excel)

    "MSEXCELROOKIE" <> wrote in message
    news:...
    >
     
    Ron Coderre, Jun 4, 2007
    #2
    1. Advertisements

  3. Guest

    Gord Dibben Guest

    In one cell type this is line one then Alt + ENTER then type this is line
    two.

    The Alt + ENTER gives you a carriage return in the cell.


    Gord Dibben MS Excel MVP

    On Mon, 4 Jun 2007 15:30:01 -0700, MSEXCELROOKIE
    <> wrote:
     
    Gord Dibben, Jun 5, 2007
    #3
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Guest
    Replies:
    4
    Views:
    419
    Guest
    Dec 11, 2004
  2. Replies:
    2
    Views:
    402
  3. Guest
    Replies:
    3
    Views:
    389
    gls858
    May 6, 2005
  4. Guest

    Insert a new row with data from previous row

    Guest, Aug 8, 2005, in forum: Microsoft Excel New Users
    Replies:
    1
    Views:
    213
    Guest
    Oct 3, 2005
  5. Rose Davis

    moving every other row up 1 row to the next column

    Rose Davis, Aug 24, 2005, in forum: Microsoft Excel New Users
    Replies:
    7
    Views:
    3,378
    Rose Davis
    Aug 25, 2005
  6. Guest

    Reset bottom print margin to row 300 from row 66,000.

    Guest, Mar 14, 2007, in forum: Microsoft Excel New Users
    Replies:
    2
    Views:
    244
    Guest
    Mar 15, 2007
  7. Brian Pollard

    Best way to find row number of last row containing data

    Brian Pollard, Jun 18, 2007, in forum: Microsoft Excel New Users
    Replies:
    1
    Views:
    321
    Dave Peterson
    Jun 18, 2007
  8. DARKMAN

    calculating row by row

    DARKMAN, Aug 25, 2008, in forum: Microsoft Excel New Users
    Replies:
    1
    Views:
    193
    JLatham
    Aug 26, 2008
Loading...