How to set printer specific info on all sheets in workbook
Try publishing as (or printing to) a PDF file and then set the greyscale and one-sided settings when printing the PDF.
Related videos on Youtube
daramarak
Software developer, familiar with C,C++,Python,BBC Basic, Pascal, ARM Assembler. Currently writing software for sensors in the machine tool industry.
Updated on September 17, 2022Comments
-
daramarak almost 2 years
We have a 53 page workbook in excel. It is instructed to print this in greyscale and with one page per sheet of paper. The only way I have been able to accomplish this is this way:
- I select the pages I need to print
- select print preview
- press page setup
- select options... from the dialog.
- Then on the printers own printer dialog i select one sided and greyscale.
- press ok
- go to next page... and repeat
This is kind of tiresome, and I also notice that the printer settings is set for that page also for the future. So I know that excel can store the printer options.
So how can I tell excel to print the whole workbook with the same options.
Please do not tell me to select all sheets, then selecting page settings, and set the options. This doesn't work. Somehow the press on "options..." and editing the printer dialog does only affect the selected page.
-
daramarak over 13 yearsThat is a workaround that might work, but I would prefer a way that makes Excel do what I want, and not have to rely on a two-step method.
-
JMac over 5 yearsThis doesn't actually solve the issue. When you try this, it only applies the option for the first page, then starts printing double sided for the rest (this issue was never resolved for Excel 2010). This is the primary issue OP is running into.