Questions

Print all Excel worksheets in color

+
0 Votes
Locked

Print all Excel worksheets in color

macreardon
In our company we have set the print server drivers for color printers to print in black and white (it is more economical that way).
That means when you need to print an Excel worksheet in color, you just need to change the printer properties in the Print windows and choose color as quality. That's ok, but when we choose to print the whole document in color, it is only the last selected worksheet which prints in color. In order to print all in color, we need to go in each and every worksheet and change the b/w to color settings.
We think that Excel takes the b/w info from the driver on the print server.
Does anybody know how to tell Excel to print all worksheets in color (it probably means accessing the driver) ?
+
0 Votes
TG2
Collapse -

what happens if you select all the worksheets first?

at the bottom left corner of excel you have a series of arrows to move to the first, previous,next, and last sheets.

go to the first sheet, click on it to select, then hit the button (arrow) to get the last sheet, hold down SHIFT, and click that last sheet's name.

Then go into file print.. and then set the color options..

+
0 Votes
macreardon
Collapse -

I did that test as well (even with brand-new Excel Workbook), but it didn't work. If you select all worksheets, the one which is highlighted in bold is the one which gets the color change in the driver properties. I even tested by creating a fictious printer (HP Color LaserJet 5M) on LPT1-port. If you set black&white as print options, it is only the bold highlighted worksheet which gets the color setting. The reverse is quite true as well : if you leave the printer as color, if you want to print the whole workbook in b&w, only the first selected worksheet will be in b&w, the others in color...

+
0 Votes
justins
Collapse -

Has anybody found a solution for this? The only thing I can think of is to setup an additional printer that is defaulted to color and select that printer. I am not 100% sure that will work but I think it might.

If anybody has a fix for this, that would be highly appreciated. Thank you.

Justin

+
0 Votes
Dean.Brown
Collapse -

You can select more than one worksheet at a time by useing the ctrl or Shift key. Then got to File, Page Setup, to manage the color Properties.

But this didn't fix my Print Preview issue. All my print previews are in black and white for some sheets only. Must be another property that is hidden.

+
0 Votes
BartEvers
Collapse -

Hi, I have looked and tried a lot and I found out that the problem is within the PCL dirver. I had the PCL 6 driver installed on the print server.

With the PS driver it was printed all in color.

I opened a case with HP so that they fix that bug.

Greetz,
Bart

+
0 Votes
Collapse -

Hi,
Im facing the same problem.
I founded this in another forum ... try it...

-------------------------------------------------------------------------------------------------------------

Select all worksheet to set to BW
Go into page setup --> Sheet --> check black and white.
now print all wokbook on a color printer.
Only selected workbook will be printed as black and white.
I hope it help

+
0 Votes
benliaw
Collapse -

What I did in my company is to create two different printers for the same printer. In your situation, I would create one called Printer (C) and another called Printer (B). If I want to print in color, then I sent to Printer (C) and if I want to print in just black, I would sent it to Printer (B).

+
0 Votes
bensaved
Collapse -

Necrobump, I know, but this problem is still there. I have two customers who are having this issue now, and need a solution. Though interesting, the above workaround is much less than ideal for them. Does anyone know how to set the print setting for the entire workbook at print time?