Results 1 to 7 of 7

Thread: I have a silly question about Microsoft Excel.

  1. #1
    KentaRawr!'s Avatar
    Join Date
    Aug 2004
    Location
    Earth!
    Posts
    8,314
    Blog Entries
    3

    Default I have a silly question about Microsoft Excel.

    Well, I'm trying to make an Excel Sheet, you see. However, despite there being enough room for more text (vertically), the text I write kinda just leaks out into the cell next to it, being all "lolz hey man wazzup in here". So, basically, I'd like my text's awful habits to end, so that it may stay in the cell of which it belongs.

    :mog:

  2. #2
    trancekuja's Avatar
    Join Date
    Dec 2008
    Location
    The Elm Chanted Forest
    Posts
    638

    Default

    hm..I'm not quite sure if I understand the question but try : Format Cells : Text control : Wrap text -check this box

  3. #3
    Banned
    Join Date
    May 2007
    Location
    UK
    Posts
    8,125
    Blog Entries
    17

    Default

    Go to the top where the column letters are and drag the side.

  4. #4
    Draw the Drapes Recognized Member rubah's Avatar
    Join Date
    Dec 2004
    Location
    Now Destiny is done.
    Posts
    30,655
    Blog Entries
    21
    Contributions
    • Former Administrator
    • Former Cid's Knight

    Default

    if you're going to follow dd's advice, at least double click them so they'll auto-size.

  5. #5
    I have one of these now Nominus Experse's Avatar
    Join Date
    Jun 2006
    Location
    Here
    Posts
    4,884

    Default

    You have a number of options:

    Wrap Text
    Shrink to Fit
    Justify
    Distributed
    Expanding the row/column
    Merging cells
    ...

  6. #6
    Slothstronaut Recognized Member Slothy's Avatar
    Join Date
    Jun 2005
    Location
    I'm in space
    Posts
    13,565
    Blog Entries
    27
    Contributions
    • Former Cid's Knight

    Default

    Quote Originally Posted by Nominus Experse View Post
    You have a number of options:

    Wrap Text
    Shrink to Fit
    Justify
    Distributed
    Expanding the row/column
    Merging cells
    All of these are good options. I'd recommend wrap text or expanding the row or column myself though.

  7. #7
    rowr Recognized Member Leeza's Avatar
    Join Date
    Aug 2001
    Location
    The long hard road out of hell.
    Posts
    17,979
    Contributions
    • Former Administrator
    • Former Cid's Knight

    Default

    Wrap text. Alt + Enter will also give you a hard return in the same cell.

    Double clicking on the top right side of the column will auto-fit the column to the text, but sometimes that gives you too much text on one line.
    Hello Pika Art by Dr Unne ~~~ godhatesfraggles

Posting Permissions

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