Printing Excel spreadsheet in color

  • One of our sales people created a spreadsheet with just text in 6 columns and 28 rows. Each row's text was typed in different colors, ie. red for column A, green for column B, etc. When either he or I try to print it - it prints in black and white. I even tried to put the column patterns in colors and it printed in white. Any clues?

  • Hi,

    Have you checked Black and White option for that worksheet ?

    Click File_Page Setup and select Sheet Tab then look for the Black and White checkbox is checked in Print section. If checked then uncheck it and click ok.

    I hope this helps.


  • Didn't even know that was there and that it was the default setting. Why would that be set up as the default Mr. Gates? Oh, another question for Microsoft. Thanks everyone.


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!