1. Welcome Guest! In order to create a new topic or reply to an existing one, you must register first. It is easy and free. Click here to sign up now!.
    Dismiss Notice

excel2007 - unwanted change in printpreview

Discussion in 'General Software' started by Sebastian42, Jul 16, 2015.

  1. Sebastian42

    Sebastian42 Registered Members

    Joined:
    Jun 2, 2012
    Messages:
    22
    Location:
    Sydney, Australia
    Operating System:
    Windows 8
    When I arrange the worksheet columns to be only as wide as they need to be, the print preview (and the actual print out) has extra space after (to the right of) the last entry in the cell. So a cell that looks like : |xxx|, when printed, looks like : |xxx |. Can that be remedied ? The work-around I have found, is to make the original columns too narrow, so that some contents are hidden from view - that is really a quite undesirable method, though it achieves a 'correct' printout.
     
    Sebastian42, Jul 16, 2015
    #1
  3. Tony D

    Tony D Administrator Administrator

    Joined:
    Sep 25, 2009
    Messages:
    5,157
    Location:
    SE Pennsylvania, USA
    Operating System:
    Windows XP Professional
    I tried to duplicate your scenario. I think I can see what you're talking about, but it's not real obvious to me. It might be a limitation of Excel. Perhaps you can use the Concatenate function to join text in two cells into one cell.
     
    Tony D, Jul 16, 2015
    #2
  4. Sebastian42

    Sebastian42 Registered Members

    Joined:
    Jun 2, 2012
    Messages:
    22
    Location:
    Sydney, Australia
    Operating System:
    Windows 8
    I already have a work-around, which I would prefer to concatination; I am still hopeful of finding a 'solution' rather than a work-around. It is only in THIS workbook that printed width concerns me, so maybe it is a usual phenomenon, but I have never noticed it before. I also posted this in www.excelkey.com/forum/.... but was unable to draw a response, so I tried CHF. Thanks for your suggestion.
     
    Sebastian42, Jul 16, 2015
    #3
  5. Tony D

    Tony D Administrator Administrator

    Joined:
    Sep 25, 2009
    Messages:
    5,157
    Location:
    SE Pennsylvania, USA
    Operating System:
    Windows XP Professional
    One other thing to try is to change fonts There are mono-spaced and variable spaced fonts. If you're using a variable space font like Arial, try changing to a mono-space font like Courier and vice-versa. There might be something in the font characteristic that's telling Excel to leave some space. I'm just reaching here, but who knows?
     
    Tony D, Jul 16, 2015
    #4
  6. Sebastian42

    Sebastian42 Registered Members

    Joined:
    Jun 2, 2012
    Messages:
    22
    Location:
    Sydney, Australia
    Operating System:
    Windows 8
    Changing font to Courier produces no improvement.
     
    Sebastian42, Jul 16, 2015
    #5
  7. Tony D

    Tony D Administrator Administrator

    Joined:
    Sep 25, 2009
    Messages:
    5,157
    Location:
    SE Pennsylvania, USA
    Operating System:
    Windows XP Professional
    Oh well. Looks like it's an Excel issue.
     
    Tony D, Jul 16, 2015
    #6
  8. Rich M

    Rich M Guest

    Joined:
    Dec 24, 2013
    Messages:
    4,580
    Location:
    NE Pa USA
    Operating System:
    Windows 7
    Computer Brand or Motherboard:
    MSI Z97 PC Mate LGA 1150 Intel Z97
    CPU:
    Intel i7 4790K 4.0Ghz
    Memory:
    Corsair Vengeance 16GB (2x8GB) DDR3 2133
    Hard Drive:
    Crucial 256 Gb SSD+ WD Raptor 300 Gb Sata III
    Graphics Card:
    Radeon R9 280 2GB HDMI
    Power Supply:
    Seasonic 750 watt
    I don't think the issue is with Excel, sounds more like the printer is not printing what it is showing so you need to shange the printing format and every printer is different of course.
     
    Rich M, Jul 16, 2015
    #7
  9. Tony D

    Tony D Administrator Administrator

    Joined:
    Sep 25, 2009
    Messages:
    5,157
    Location:
    SE Pennsylvania, USA
    Operating System:
    Windows XP Professional
    Rich - if you read the first post, the print preview shows the same phenomenon as the actual print out.
     
    Tony D, Jul 16, 2015
    #8
  10. Rich M

    Rich M Guest

    Joined:
    Dec 24, 2013
    Messages:
    4,580
    Location:
    NE Pa USA
    Operating System:
    Windows 7
    Computer Brand or Motherboard:
    MSI Z97 PC Mate LGA 1150 Intel Z97
    CPU:
    Intel i7 4790K 4.0Ghz
    Memory:
    Corsair Vengeance 16GB (2x8GB) DDR3 2133
    Hard Drive:
    Crucial 256 Gb SSD+ WD Raptor 300 Gb Sata III
    Graphics Card:
    Radeon R9 280 2GB HDMI
    Power Supply:
    Seasonic 750 watt
    OK I see that Tony yet actually that makes me even feel more so the printer is the issue.
     
    Rich M, Jul 16, 2015
    #9

Share This Page