excel not printing all worksheets in color

Posted on 2011-10-03
Medium Priority
Last Modified: 2012-08-14
strange issue..

when one of my users prints in color only the sheet that is currently selected being printed in color...all others come out in grey no matter what the selection is on any printer. I double checked all all printers are selected to print in color.

I am using MS Office 2007
Question by:sbodnar
  • 2
  • 2

Expert Comment

ID: 36905955
You're not going to like the answer....

I believe when you go to print the workbook and choose the color option it's for that initial sheet you have open only.  I don't want to waste color pages as much as you don't so my testing options are limited....

Try selecting each page individually and setting the print properties to color individually.  See if that fixes it...maybe start with 2 pages.  Also, you could try slecting all pages by shift + mouse clicking each sheet and then setting the print properties...that might hit them all in one shot!
LVL 19

Expert Comment

by:Arno Koster
ID: 36916422
If i printout a number of excel sheets, all pages come out in color corresponding to the regular settings. When I then set the 'print in b/w' setting indeed only the first page is printed in b/w.
This holds for both printing by the complete workbook option and also for selecting all sheets and print selected sheets.

LVL 19

Accepted Solution

Arno Koster earned 1000 total points
ID: 36916516
It seems that multiple other forums also dived into this problem and presumably only 2 workaraounds can be found :

1) print each worksheet seperately (by hand or using macro code)
2) print the selected worksheets to file and send this file to the printer

as in this forum :
Humar September 10, 2009 at 11:00:16 Pacific
Try printing to file first.
Then send the file to the printer.
I used a freeware program 'PrintFile' to send the file to the printer - see www.lerup.com/printfile/
I had two worksheets with coloured text, then printed the 'Entire Workbook' with Print To File Checked.
Name the file C:\ Anything.prn or whatever suits you
Open the PrintFile program
Set it up with the Printer you want to use
Then drag the file onto PrintFile's Main Window
When you drag the Anything.prn file onto the PrintFile Program's Main Window, it allows you to set printer options. I selected Monochrome, and both sheets in my Workbook printed in B & W
I obviously don't have the same printer setup as you, but logically it sounds as though it might work for you.
PS there may be other ways to send the file to the printer rather than using this freeware program.

Author Comment

ID: 36916644
ughh... so I guess I have to print each page in color huh?

Expert Comment

ID: 36916680
Well....if you have direct control over your printer you could set the default to B/W and then use that queue.

One more alternative, Microsoft includes other printing options like a plugin with adobe and it's on file printer like AKOSTER mentioned above.  If you turn it in to a PDF or another format first and then print the document, you might get lucky.  It is an Excel file so the formatting may not be what you expect but it's worth a try.  Check you printers when trying to print the Excel file.  You may be surprised to find some 'printers' you ddin't notice before.

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Currently, there is an issue with being able to copy values from an external application to a dropdown list in Project Web Access (PWA).  The standard copy and paste methods don't seem to work properly. Here is a way to accomplish this task to s…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question