Results 1 to 3 of 3
  1. #1
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Swanzey, New Hampshire, USA
    Posts
    1,707
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Entering multiple lines in a cell? (2003 SP-2)

    I'm a total newbie when it comes to Excel. To say I find Excel daunting would be an understatement. <img src=/S/RollEyes.gif border=0 alt=RollEyes width=19 height=19> What I would like to know is an easy way to insert multiple lines of text within a cell. Yes, I've read the "Help" section on doing this, e.g.,

    1. Select the cells you want to format.
    2. On the Format menu, click Cells, and then click the Alignment tab.
    3. Under Text control, select the Wrap text check box.

    But the problem I'm having is getting specific lines of text to be on its own line. For example, I want my entry to be:

    This is line one.
    This is line two.


    What I usually end up with is something like:

    This is line one. This is
    line two.


    I've tried typing the desired text in the "Insert Function" field, and entering it that way, but that was a disaster. Soooo, I would like to believe that what I want to do is a very simple thing, the means of which escapes me. HELP!! <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    Jeff
    Jeff
    simul iustus et peccator

  2. #2
    Silver Lounger
    Join Date
    Oct 2002
    Posts
    1,993
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Entering multiple lines in a cell? (2003 SP-2)

    For individual cells when writing, I would use this method: Press Alt-return when you want to break.

    Wrap via Format, for me, is more like when I know which cells need this before, or if I have to change after.

    In your case, I think you have to adjust the column width.

  3. #3
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Swanzey, New Hampshire, USA
    Posts
    1,707
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Entering multiple lines in a cell? (2003 SP-2)

    Thanks!! <IMG SRC=http://www.the-highway.com/Smileys/BigThumbUp.gif> The "alt+Enter" suggestion worked perfectly. It's too bad the Help section doesn't mention this simple approach to entering multiple lines in a cell.
    Jeff
    simul iustus et peccator

Posting Permissions

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