Results 1 to 6 of 6
  1. #1
    Uranium Lounger
    Join Date
    Mar 2001
    Location
    New Jersey
    Posts
    6,684
    Thanks
    1
    Thanked 11 Times in 11 Posts

    Excel File Prints Small (XP SP Unknown)

    A neighbor posed this question to me tonight and I could only guess at the cause as I am not familiar with Excel.

    One Excel file views normally on the screen, but when the file is printed it prints out very small (font, graph and all). He says that the problem began, and is only with this file, when he started entering page breaks. Says that the more page breaks he adds, the more the problem persists and makes things ever smaller. I have not seen the computer and can only guess, at this point, what the cause could be. I am leaning to the page breaks as the cause, but don't know what other issues could be causing the printout to be so small when the screen view appears normal. Ideas...thoughts ???

    Thanks.
    <IMG SRC=http://www.wopr.com/w3tuserpics/DocWatson_sig.gif>

  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: Excel File Prints Small (XP SP Unknown)

    Not sure exactly what is being done, but if you go to page break preview and start adjusting the page breaks in this view, XL will adjust the printing size to fit as much as you want on the page. If and when this is done, the font size may get small.

    It can also just occur if you tell XL to print everything to one page and XL thinks the sheet has more on it than the user does (a cell in bottom right was formatted for example).

    Steve

  3. #3
    Uranium Lounger
    Join Date
    Mar 2001
    Location
    New Jersey
    Posts
    6,684
    Thanks
    1
    Thanked 11 Times in 11 Posts

    Re: Excel File Prints Small (XP SP Unknown)

    Thanks for the reply Steve. <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    I'm not sure what is being done and I suppose the only way to get to the bottom of this is to go over to his place and sit down at the machine myself. I'll post back after I do, but any thought or comments in the interim will be appreciated.
    <IMG SRC=http://www.wopr.com/w3tuserpics/DocWatson_sig.gif>

  4. #4
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel File Prints Small (XP SP Unknown)

    File > Page Setup...

    As Steve suggests, check the scaling. If it is not set to 100%, see how many pages Excel thinks it should print in File > Print Preview...
    Attached Images Attached Images
    • File Type: gif x.gif (12.5 KB, 0 views)

  5. #5
    Uranium Lounger
    Join Date
    Mar 2001
    Location
    New Jersey
    Posts
    6,684
    Thanks
    1
    Thanked 11 Times in 11 Posts

    Re: Excel File Prints Small (XP SP Unknown)

    Thanks for the graphic Leif. <img src=/S/smile.gif border=0 alt=smile width=15 height=15> That seems to be something he was referring to last night. I will call him today and see if I can get an email address from him so I can perhaps solve this remotely. Pictures really can say 1,000 words.
    <IMG SRC=http://www.wopr.com/w3tuserpics/DocWatson_sig.gif>

  6. #6
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Cleveland, Ohio, USA
    Posts
    388
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel File Prints Small (XP SP Unknown)

    Best wishes for the new year upon us all and for all the troubleshooting that will befall us!!

    Any update on this printing issue?

    Thanks,

    Jester
    I know enough to know I don't know enough

Posting Permissions

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