Results 1 to 6 of 6
  1. #1
    5 Star Lounger
    Join Date
    Jul 2004
    Location
    Ohio
    Posts
    629
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Word cut off in cell (2k)

    I have a cell that i need to keep at a certain width and i have columns next to it. But i don't want the text to continue past the end of the cell and i can't find any settings in format cell to stop this... any way to do this?
    <img src=/w3timages/blueline.gif width=33% height=2>
    <big>John</big>

  2. #2
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Word cut off in cell (2k)

    I believe what you are looking for is "wrap text". It is located under the dropdown for Format>Cells>Alignment under "text controls" click on "wrap text".

    You may need to change the height of the row.

    Regards,
    John

  3. #3
    5 Star Lounger
    Join Date
    Jul 2004
    Location
    Ohio
    Posts
    629
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Word cut off in cell (2k)

    yeah i don't wanna do that <!t>[edit: I don't wanna do it because it makes the cell heights absurdly large]<!/t>

    i put a space in the cells in the next column, seems to do what i want well enough <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>
    <img src=/w3timages/blueline.gif width=33% height=2>
    <big>John</big>

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

    Re: Word cut off in cell (2k)

    You can also tick the "Shrink to fit" check box in the Alignment tab of Format | Cells...

  5. #5
    5 Star Lounger
    Join Date
    Jul 2004
    Location
    Ohio
    Posts
    629
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Word cut off in cell (2k)

    tried that Hans, it made the text in the cells the size of a single celled organism <img src=/S/alien.gif border=0 alt=alien width=14 height=15>
    <img src=/w3timages/blueline.gif width=33% height=2>
    <big>John</big>

  6. #6
    5 Star Lounger
    Join Date
    Jul 2004
    Location
    Ohio
    Posts
    629
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Word cut off in cell (2k)

    scratch that, my boss said to take that column out <img src=/S/bash.gif border=0 alt=bash width=35 height=39>
    <img src=/w3timages/blueline.gif width=33% height=2>
    <big>John</big>

Posting Permissions

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