Excel – How to print an Excel Spreadsheet as Grayscale

microsoft excelprinting

I would like to print my filled cells in a different color to match the rest of my document. The filled cells contain green background and blue font. I want the cells to automatically print to grey background and black font. I do not want to have to go through my document and manually change the font and shading.

Is it possible to print the file as grayscale? Or, could someone provide me with a macro or code that would solve this problem?

Best Answer

Follow these steps:

  1. Select your Printer and then click on Printer Properties. (Right now, you can see the preview shows our sheet in color).

    Print Preview shown in Color

  2. In Paper/Quality Tab, change the Color Setting to Black & White.

    Printer Properties

  3. As you can see, the preview turns to Grayscale and the sheet would print out in Gray background and black font.

    Print Preview shown in Black & White