Save print settings

Solved
Marquisette65 Posted messages 13 Status Membre -  
Le Pingou Posted messages 12375 Registration date   Status Contributeur Last intervention   -
Hello,

I have an Excel file that I use regularly to print my sheets at the end of the month, and each time I want to print two pages per sheet. But every time I print, I have to go and change this setting and recheck the print preview option.

How can I make it so that it's saved?

Thank you!

4 réponses

Le Pingou Posted messages 12375 Registration date   Status Contributeur Last intervention   1 476
 
Hello,
Open the workbook, go to File then Print, and in the right window under Copies set it to 2 and finish with Save.

--
Regards.
The Penguin
0
Marquisette65 Posted messages 13 Status Membre
 
Hello,
thank you for your response, but if I understood correctly, this manipulation would allow printing two copies of the same sheet, right?
0
Le Pingou Posted messages 12375 Registration date   Status Contributeur Last intervention   1 476
 
Hello,
Well yes, that’s what I understood.
If not then complete the explanation… !

--
Regards.
The Penguin
0
Marquisette65 Posted messages 13 Status Membre
 
Hello,

oops, I misspoke.
I would like to modify the printing layout to print "two pages per sheet" and "show the preview." This is entirely doable by going into the printing properties, but it resets every time, so I have to go back and set these parameters again. I'm looking for where I can save my choices.

Thank you!
0
Le Pingou Posted messages 12375 Registration date   Status Contributeur Last intervention   1 476
 
Hello,
You need to make the adjustments in the printer settings.
In the Control Panel under Devices and Printers, open the printer and set your printing preferences, then finish by clicking Apply.

--
Best regards.
The Penguin
0
Marquisette65 Posted messages 13 Status Membre
 
Hello,

thank you and sorry for my late reply. But with my Windows 8, I have no printing options available in the control panel... :(
0
Le Pingou Posted messages 12375 Registration date   Status Contributeur Last intervention   1 476
 
Hello,
Well, if you have the option from the document, you should also have it from the control panel, whether it's Windows 8 or otherwise.
Did you find the printer in the control panel...?

--
Regards.
The Penguin
0
Marquisette65 Posted messages 13 Status Membre
 
Hello,

Yes, I found it and I end up on the same window as when I go through my document to print, properties...
But you were right, by modifying the properties from the control panel, they are saved!!!
Thank you very much!!!!
0
Le Pingou Posted messages 12375 Registration date   Status Contributeur Last intervention   1 476
 
Thank you, you're welcome, happy for you.
Best regards.
The Penguin
0