ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Printing different work sheets in colour when the default is b&W (https://www.excelbanter.com/excel-worksheet-functions/230476-printing-different-work-sheets-colour-when-default-b-w.html)

Wavey Davey

Printing different work sheets in colour when the default is b&W
 
if you have a multiple worksheet document and the printer defauls to mono and
duplex but you wish the whole document to be printed in colour and simplex is
the only way of achieving this to chage the printer setup on each and every
worksheet?

thank you very much for any guidance.

Gav123

Printing different work sheets in colour when the default is b&W
 
Hi,

Maybe if you group all the worksheets (click the first worksheet tab, hold
shift key and click on the last worksheet tab) then you can set your printer
settings. Remeber to ungroup when finished.

Hope this helps,

Gav

"Wavey Davey" wrote:

if you have a multiple worksheet document and the printer defauls to mono and
duplex but you wish the whole document to be printed in colour and simplex is
the only way of achieving this to chage the printer setup on each and every
worksheet?

thank you very much for any guidance.


Wavey Davey[_2_]

Printing different work sheets in colour when the default is b
 
unfortunatly that doesn't work, the first page/worksheet will come out
correctly then all the subsequent ones will be mono duplex etc.
thanks anyway

"Gav123" wrote:

Hi,

Maybe if you group all the worksheets (click the first worksheet tab, hold
shift key and click on the last worksheet tab) then you can set your printer
settings. Remeber to ungroup when finished.

Hope this helps,

Gav

"Wavey Davey" wrote:

if you have a multiple worksheet document and the printer defauls to mono and
duplex but you wish the whole document to be printed in colour and simplex is
the only way of achieving this to chage the printer setup on each and every
worksheet?

thank you very much for any guidance.



All times are GMT +1. The time now is 01:08 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com