different printout when changing printer

lalbatros

Well-known Member
Joined
Sep 5, 2007
Messages
659
Hello,

I had to print my big workbook with a different printer.
I had to re-adjust the page setup of more than 20 pages.
Except for the printer there should have been no difference (same size, orientation, ... nothing changed)

Is there a way to avoid that?
What is the reason?

Thanks,

Michel
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
The reason is different printers and printer drivers. Each printer will accept only certain instructions from the computer and each printer has different capabilities. I sometimes think of the driver as a language translator. Does the printer use the instruction language for Epson color inkjets produced before 2015 or does it use the Canon language for black and white laser printers produced this year?

The only way to ensure a reasonably printer agnostic printout of your document is to save it as a pdf and then print the pdf.
 
Upvote 0
Thanks for the answer.
I still can't understand why what would work with the pdf intermediate step would not be automated by any driver. (postscript?)
I asked the question because I had a terrible case that took me quite some time and attention to adjust.
I wonder if this is a Windows only feature?
 
Upvote 0
PDF does stand for Portable Document Format. I think it's a bit more than just Postscript. I remember when printers were advertised with Postscript capabilities as a feature. An Excel document is both text and images (and audio and 3D images).

As I understand it, a pdf places text and images using an x-y coordinate system. I guess it could be likened to an image of a document.

You can add audio and video to a pdf, and that may be a case of creeping featurism, but it could also be useful. The document becomes a portable website, without the need for an internet connection.
 
Last edited:
Upvote 0
I wonder if this is a Windows only feature?
Nope. Its a printer issue.
A lot of printers have what is called a "printable area" & this will vary from one printer to another.
So a page that will fit on one sheet of paper on one printer, may need mores sheets on another printer.
 
Upvote 0

Forum statistics

Threads
1,214,944
Messages
6,122,391
Members
449,080
Latest member
Armadillos

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top