fill colours not printing

P

Peter

Hi
I have a workbook with several sheets in it.
When I fill a cell with a background colour or pattern on the first sheet
the colour and/or pattern do not print or appear on print pre-view. On
other sheets in the workbook fills appear correctly. Is there a switch
somewhere I've missed although it's hard to see how only one sheet can be
affected.

Peter
 
G

Gord Dibben

Peter

File>Page Setup>Sheet.

Uncheck "Black and White" and/or "Draft Quality"


Gord Dibben MS Excel MVP
 
P

Peter

Thanks - I remember now. Strange thing is I tried using a black & white
pattern & this too failed to show.

Peter
 
Top