one of my worksheets has colours on screen but prints only in bw

  • Thread starter Thread starter PeterA
  • Start date Start date
P

PeterA

all in Excel 2007; I have other worksheets which print the screen colours; I
must have changed one of the commands in the one spreadsheet but don't know
which command.
 
Most likely you've set the Black and White print option, check here:
Page Layout tab, Sheet Options group - click the expand button at the lower
right of the group. On the [Sheet] tab, clear the checkbox next to "Black
and white".
 
Back
Top