Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    Sep 2001
    Location
    NJ
    Posts
    26
    Thanks
    0
    Thanked 0 Times in 0 Posts

    cell too small (excel 2000)

    I recently printed a report, only to discover that there were two lines of data in one cell.
    On one printer, the report only printed the first line.
    On a second printer, it printed both lines.
    On a third printer it overtyped the second line over the contents of the cell below.
    The first case is of highest concern, since I could be losing data (horizontally and vertically) without getting any warning.

  2. #2
    3 Star Lounger
    Join Date
    Jul 2001
    Location
    Long Beach, California, USA
    Posts
    233
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: cell too small (excel 2000)

    Not knowing what data you have, you could use the AutoFit to Selection command in the Format menu. Another thing to try is to choose Wrap Text under the Alignment tab / Format Cells. You may have reset the print area.

    Brent

  3. #3
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: cell too small (excel 2000)

    Can we assume that when you say "two lines of data in one cell", you mean that the data contains a lot of characters and is wrapping on screen in the formula bar and in in-cell editing?

    If Brent hasn't solved your problem, another thought is to expand the column width. Click on the column header to select the column containing this cell, move the cursor near the right edge of the column header until the "Cross with arrows" pointer appears, and double click.
    -John ... I float in liquid gardens
    UTC -7ąDS

  4. #4
    3 Star Lounger
    Join Date
    Jul 2001
    Location
    Long Beach, California, USA
    Posts
    233
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: cell too small (excel 2000)

    <img src=/S/blush.gif border=0 alt=blush width=15 height=15> .... I was in a hurry to get to a meeting and didn't specify Format / Column / AutoFit to Selection. Sorry about that.

    Brent

  5. #5
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Kortrijk, Belgium
    Posts
    571
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: cell too small (excel 2000)

    It's just a thought, but could it be that there are some non-printable characters in the strings (control-characters, which might be interpreted differently according to your printer settings?). You can get rid of this by using the CLEAN worksheetfunction. e.g. if your line of data is in cell A1, put =CLEAN(A1) in cell B1 and have a look if it prints differently.

Posting Permissions

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