Thanks Thanks:  0
Likes Likes:  0
Results 1 to 9 of 9

Thread: General printring question

  1. #1
    MrExcel MVP Von Pookie's Avatar
    Join Date
    Feb 2002
    Location
    The act or process of locating.
    Posts
    13,686
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Why is it that sometimes I have a sheet that I print which is set to be centered in the page, no extra rows in the print area, etc., but still prints out closer to one side than the other?

    I had to use "fit to 1 page" and the right and left margins are exactly the same.

    Has anyone else ever had this happen?

    Thanks,

    _________________
    Kristy

    "There are two means of refuge from the miseries of life: music and cats." - Albert Schweitzer

    [ This Message was edited by: Von Pookie on 2002-04-09 11:19 ]

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Meeeeeeeoeoeowww !

    Have you looked at "centre horizontally / vetrically" in print setup ?

    also, and this is a real pain, you may need to look at your printhead alignements within the printer setup from the start menu (I'd advise against it though as it deals in milli-microns of an inch)


    :: Pharma Z - Family drugstore ::

  3. #3
    MrExcel MVP Von Pookie's Avatar
    Join Date
    Feb 2002
    Location
    The act or process of locating.
    Posts
    13,686
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Chris!

    I have the sheet checked for center horizontally (which is one of the main reasons of why it's really buggering me that it's not working).

    I also have checked the print area and the page break preview to make sure there weren't any extra rows off to the side, but no. Starts at A1, with nothing off to the left that would be pushing it over, far as I can see.

    I've managed to fix it on some other sheets before, but can't remember what I did. I assume it was a fluke that I even got it.

    Thanks!
    Kristy

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    Houston, TX
    Posts
    359
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Did you check the print margins?

  5. #5
    MrExcel MVP Von Pookie's Avatar
    Join Date
    Feb 2002
    Location
    The act or process of locating.
    Posts
    13,686
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    • The left and right margins are both set at 0.5
    • The "center horizontally" box is checked
    • Fit to one page is checked
    • There are no extra rows hiding in the print area
    • Print preview shows it centered like it should come out as
    • When printed, it comes out with at least 1 inch from the left side of the page to the left side of the chart; not centered on the page.


    Ugh.

    Thanks,

    _________________
    Kristy

    "There are two means of refuge from the miseries of life: music and cats." - Albert Schweitzer

    [ This Message was edited by: Von Pookie on 2002-04-11 07:28 ]

  6. #6
    New Member
    Join Date
    Apr 2002
    Location
    Durban, South Africa
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have had this occur when the paper size is set for Letter and not A4. Try changing your print settings and see if this works.

    Good luck
    Murray

  7. #7
    MrExcel MVP Von Pookie's Avatar
    Join Date
    Feb 2002
    Location
    The act or process of locating.
    Posts
    13,686
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks, Murray, but I want it on letter size (I'm in the US!)
    Kristy

  8. #8
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    also, and this is a real pain, you may need to look at your printhead alignements within the printer setup from the start menu (I'd advise against it though as it deals in milli-microns of an inch)
    so did you ?!

  9. #9
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Does there not being a drop down choose US letter or US legal, again this i thinks is DSP not oem software in 97 2000, xp im on now horrid it is..


    also i suggest drivers, check latest and remove and renew if network drivers to spool print bent the IT managers arm

    Ill be very blunt proove him his network stinks them he sort it out IT staff (hey in IT but work in Fianace) dont like being proved wrong they will listen and do ZERO not they they cant or wont but they see it as you not them, i love my IT staff, i pray soon ill joint them.

    re load and set as default settings then print and select US .. as needed.. that will do it im sure..


    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

Some videos you may like

User Tag List

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
  •