Results 1 to 6 of 6

Cell contents cutting off

This is a discussion on Cell contents cutting off within the Excel Questions forums, part of the Question Forums category; We have run into issues with cell contents cutting off. Even when using the auto-fit options, contents are still often ...

  1. #1
    New Member
    Join Date
    Sep 2009
    Posts
    3

    Question Cell contents cutting off

    We have run into issues with cell contents cutting off. Even when using the auto-fit options, contents are still often cut off and with a large spreadsheet, it's time-consuming to check each cell. It primarily seems to happen to cells with a lot of text. Any thoughts? We really need to make sure all of the information is printing for outside vendors who only have hard copies available to them.

  2. #2
    MrExcel MVP
    Moderator
    Joe4's Avatar
    Join Date
    Aug 2002
    Posts
    27,697

    Default Re: Cell contents cutting off

    Welcome to the Board!

    Is your string over 255 characters long?
    If so, perhaps this is what is going on:
    http://support.microsoft.com/default...b;EN-US;168434
    TIPS FOR FINDING EXCEL SOLUTIONS
    1. Use the built-in Help that comes with Excel/Access
    2. Use the Search functionality on this board
    3. A lot of VBA code can be acquired by using the Macro Recorder.

    "Give a man a fish, feed him for a day. Teach a man to fish, feed him for life!"

  3. #3
    New Member
    Join Date
    Sep 2009
    Posts
    3

    Default Re: Cell contents cutting off

    No, it happens occassionally to cells with less than 255 characters in them.

  4. #4
    MrExcel MVP
    Moderator
    Joe4's Avatar
    Join Date
    Aug 2002
    Posts
    27,697

    Default Re: Cell contents cutting off

    Under Format Cells, on the Alignment tab, do you have the "Wrap text" option checked? Doing so may autoexpand the column vertically so that it displays all the text.

    BTW, I probably should have asked from the onset:
    1. Which version of Excel are you using?
    2. What font type and size are you using?
    TIPS FOR FINDING EXCEL SOLUTIONS
    1. Use the built-in Help that comes with Excel/Access
    2. Use the Search functionality on this board
    3. A lot of VBA code can be acquired by using the Macro Recorder.

    "Give a man a fish, feed him for a day. Teach a man to fish, feed him for life!"

  5. #5
    Board Regular sthack99's Avatar
    Join Date
    May 2006
    Location
    Virginia
    Posts
    237

    Default Re: Cell contents cutting off

    I'm having the same problem! We use Excel 2007, and it seems that the cell content keeps getting cut off even after we auto-fit everything. And yes, all cells are set to wrap text. It looks fine on the screen, but if I view it in print preview or print the sheet, it shows the bottom of some of the cells getting cut off. And some have way less than 255 characters. I spent over an hour last night going through and manually adjusting each row height on a very large spreadsheet so that all of the data was visible. And now today I'm having the same problem with a different spreadsheet! What in the world is going on, and how do I fix it???

  6. #6
    New Member
    Join Date
    Sep 2009
    Posts
    3

    Default Re: Cell contents cutting off

    We have experienced this with both MS Excel 2003 and 2007. The font we're using is Century Gothic, and we varied the size.

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com