Skip to Questions

FAQs - Search for answers or submit your questions here!

Useful Tip: Start typing your question and select a match from previously answered questions. Or, enter your question and click Ask Us.
Q

How do I get Excel to print in color?

Print preview is showing in colour and it is being sent to the colour printer but is coming out in black & white.
Last Updated: Jan 13, 2012  |  36740 Views

Was this helpful? 68   42
A

Answer

There is a quirk in Excel that can affect print jobs. To print in colour you need to:

  1. Start at the Page Layout tab
  2. Select Print Titles
  3. Click on the sheet tab.
  4. Make sure Draft Quality and Print in Black & White are both not checked.
  5. Click the Print button and choose your color printer.
  6. Click the Printer Properties link (under the Printer choices). It opens at My Tab, scroll down till you can see Select Color at lower right hand side. Change from Gray Scale to Auto Color.
  7. Open the Quality tab and confirm that Select Color shows Auto Color.
  8. Click OK to close this box.
  9. Click Print.


If you require further help, please visit the Ask Us desk at your location or contact the library by telephone (1-866-460-4430) or email.

Answered by Colleen McLeanBookmark and Share

Other Answers / Comments (5)

  1. I had the same issue, but what resolved it was verifying that the print resolution was set to above 300 DPI. Once I changed it to 600, the color appeared.
    by RJ on Apr 23, 2013.
  2. Awesome, thank you. It was the draft quality that was the kicker.
    by Denslay Hoffman on Apr 01, 2014.
  3. Perfect. Worked exactly the way you described. THANK YOU!
    by ChapStrap on Sep 27, 2014.
  4. For my version (2011 for mac) I had to go Layout/Repeat Titles/Print/Black and White. Thank you - this was a huge help and fixed the issue quickly!
    by SB on Jan 31, 2015.
  5. I had this issue what fixed it was the dpi setting not the Draft Quality or Print in Black & White under "Print Titles" like mentioned. Instead, under "Page Setup" I changed print quality from 300 to 600 dpi. 600 dpi is the only option for quality under my color printer in printer properties--so seems that they must match.
    by EM on Feb 19, 2015.

Contact

Saskatoon 306-659-4040
Moose Jaw 306-691-8228
Regina 306-775-7401
Prince Albert 306-765-1550
Toll Free (Regina) 1-866-460-4430

help.library@saskpolytech.ca

Browse by Popular Topics

Account  –  APA  –  Apprentice  –  Bookstores  –  Borrower Services  –  Circulation  –  Citation  –  Classes  –  Computer  –  Database  –  Distance  –  Electronic Resources  –  Email  –  Fine  –  Gadget  –  Hold  –  Hours  –  ILL  –  M Drive  –  Online videos  –  Password  –  Photocopy  –  PowerPoint  –  Printing  –  Program Guide  –  Reference  –  Registration  –  Remote desktop  –  Renewing  –  Request  –  Research  –  Reserve  –  Software  –  Study  –  Technology  –  Telephone  –  Testing Centre  –  Tutorial  –  Website  –  Word  
View All Topics