Skip to Questions

Ask Us! - 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.

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  |  74631 Views

Was this helpful? 118   53


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 (9)

  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.
  6. Thank you so much , it worked.
    by hyperlink on Nov 09, 2015.
  7. Excellent...thank you...this was the problem. Not sure how the box got checked...but, oh's working now....thanks again!!
    by RogerD on Jul 13, 2016.
  8. Thank you so much! Fixed the problem
    by Mindi on Aug 04, 2016.
  9. Fantastic! Easily solved. Thank you! :)
    by sheema on Apr 24, 2017.

Need More Help? Ask Us!

Browse by Popular Topics

Account  –  APA  –  Bookstores  –  Borrower Services  –  Circulation  –  Citation  –  Classes  –  Computer  –  Database  –  Digital Resources  –  Distance  –  Electronic Resources  –  Email  –  Excel  –  Fine  –  Gadget  –  Hours  –  ILL  –  M Drive  –  mySaskPolytech  –  Password  –  Photocopy  –  PowerPoint  –  Printing  –  Programs  –  Reference  –  Registration  –  Renewing  –  Request  –  Research  –  Reserve  –  Software  –  Study  –  Technology  –  Telephone  –  Testing Centre  –  Tutorial  –  Website  –  Word  
View All Topics