View original (French)

Excel 2010 Printing: Print an Entire Workbook in One-Sided

scany85 Posted messages 2 Status Membre -  
Raymond PENTIER Posted messages 58548 Registration date   Status Contributeur Last intervention   -
Hello everyone,

I need to regularly print Excel files that have several tabs. Every time I want to print, Excel defaults to:
-Printing the active sheets
-Printing double-sided

Since I need to print the entire workbook single-sided, I first change the second option to "single-sided printing." Then I change the first to "Print entire workbook." The problem is that only the first page is printed single-sided. I then have to go to each page to set them to single-sided printing. This takes a lot of time each time.

Do you know how to set the entire workbook to single-sided printing at once?

Thank you in advance.

2 réponses

Réponse 1 / 2
Raymond PENTIER Posted messages 58548 Registration date   Status Contributeur Last intervention   17 474
 
We can't really help you, since we don't know either the model of your printer or what default settings you've imposed on it...

--
Retirement is great! Especially in the Caribbean... :-)
Raymond (INSA, AFPA, CF/R)
1
scany85 Posted messages 2 Status Membre
 
The printer in question is a Ricoh Aficio MPC3001. The settings are configured for single-sided printing, with document size A4 for A4 paper format.
0