![]() |
![]() |
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
![]() |
|
|
Thread Tools | Display Modes |
|
|
#1 |
|
MrExcel MVP, Administrator
Join Date: Feb 2002
Location: The act or process of locating.
Posts: 13,679
|
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 |
|
MrExcel MVP
Join Date: Feb 2002
Location: Millbank, London, UK
Posts: 1,790
|
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 |
|
MrExcel MVP, Administrator
Join Date: Feb 2002
Location: The act or process of locating.
Posts: 13,679
|
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 |
|
Board Regular
Join Date: Feb 2002
Location: Tulsa, OK
Posts: 354
|
Did you check the print margins?
|
|
|
|
|
|
#5 |
|
MrExcel MVP, Administrator
Join Date: Feb 2002
Location: The act or process of locating.
Posts: 13,679
|
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 |
|
New Member
Join Date: Apr 2002
Location: Durban, South Africa
Posts: 3
|
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 |
|
MrExcel MVP, Administrator
Join Date: Feb 2002
Location: The act or process of locating.
Posts: 13,679
|
Thanks, Murray, but I want it on letter size (I'm in the US!)
|
|
|
|
|
|
#8 | |
|
MrExcel MVP
Join Date: Feb 2002
Location: Millbank, London, UK
Posts: 1,790
|
Quote:
|
|
|
|
|
|
|
#9 |
|
Board Regular
Join Date: Feb 2002
Posts: 3,065
|
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" |
|
|
|
![]() |
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|