Results 1 to 8 of 8
  1. #1
    2 Star Lounger
    Join Date
    Mar 2003
    Location
    Toronto, Canada
    Posts
    101
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Extra line added in Print Preview (Excel XP)

    In certain cells of my Excel spreadsheet, when I go to Print Preview it appears as if there is a blank line inserted below the text. The formatting on all cells in this column is: wrapped text, general horizontal alignment, top vertical alignment, with text direction set to 'context'. I have tried changing the formatting to various options, as well as placing my cursor at the end of the text in the cell and pressing 'delete' to remove extra spaces. The information looks fine in normal view, however in Print Preview it looks like an extra line is inserted. It does print with the extra spaces as well.
    Any help would be greatly appreciated. Thanks.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Extra line added in Print Preview (Excel XP)

    Is the row size automatic and do other columns in the row have larger font sizes or more text to wrap?

    Steve

  3. #3
    2 Star Lounger
    Join Date
    Mar 2003
    Location
    Toronto, Canada
    Posts
    101
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Extra line added in Print Preview (Excel XP)

    The font is Arial 8 for all columns and the problem cells have the longest text in them. What do I check to see if row size is automatic?

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Extra line added in Print Preview (Excel XP)

    I don't know if there is a way to check. You can make it automatic by selecting a cell in the row and format - row - autofit. This will automatically adjust the size to that needed.

    You can also move the mouse to bottom of the row indicator (where you would expand/contract the row) and double-click it to make it automatic.

    I am wondiering if the row was set manually to its current width. Autofit would make it automatic to contract and expand.

    Steve

  5. #5
    5 Star Lounger Ruff_Hi's Avatar
    Join Date
    Feb 2001
    Location
    New York, New York, USA
    Posts
    768
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Extra line added in Print Preview (Excel XP)

    Try turning your view to 'page break preview' - that often points out situations where the preview looks wrong.
    (Location Australia, then UK, but now USA. Heart, outlook, attitude, etc always Australian)
    Quote: "All Happiness is the release of internal pressure"

  6. #6
    2 Star Lounger
    Join Date
    Mar 2003
    Location
    Toronto, Canada
    Posts
    101
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Extra line added in Print Preview (Excel XP)

    Unfortunately autofit or page break preview does not fix the problem. This is a strange one! Thanks for your help so far.

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

    Re: Extra line added in Print Preview (Excel XP)

    I'm not sure that there is a solution for this problem. Excel is not really WYSIWYG, I have often noticed that it cannot calculate accurately how much space the cell contents will actually take up.

  8. #8
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Extra line added in Print Preview (Excel XP)

    You can "test" the suggestion by Hans, that it is a WYSIWYG issue by removing a couple of characters from the cell and see if the extra rows go away and row shrinks in size. If so it is probably a "WYSI (not) WYG" issue.

    Steve

Posting Permissions

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