Excel 2007 - cannot print several sheets in color

[Guest]

Since getting 2007 when I print several sheets only the first sheet comes out
in color, even though I in the print box specifically chose color. I print on
Xerox.
The rest comes out in color, like it's separate printjobs and it uses the
default printsetting which is B&W.
How do I print all my sheets in color?
Is it something I have to do in Excel or is it a Xerox or driver problem maybe

 

[Jim Rech]

Page setup is specific to the active sheet. You must make each sheet active
then go into its Page Setup and unselect Black and White.

--
Jim
| Since getting 2007 when I print several sheets only the first sheet comes
out
| in color, even though I in the print box specifically chose color. I print
on
| Xerox.
| The rest comes out in color, like it's separate printjobs and it uses the
| default printsetting which is B&W.
| How do I print all my sheets in color?
| Is it something I have to do in Excel or is it a Xerox or driver problem
maybe
|
| --
| LTJ

 

[Guest]

You can select all the sheet tabs (right-click one & select "Select All
Sheets"), then whatever settings you give to the active sheet's page setup
will be applied to all the sheets, including deselecting B&W. When you're
done, Right-click any tab & select Ungroup sheets.
Bob Umlas
Excel MVP

 

[Guest]

Thank for the tip. But that is exactly my problem. All sheets are active but
still only the first sheet comes out in color.
So I guess it must be a printer problem.

 

[Quizzy53]

LTJ - did you ever resolve this? I have the same problem in Excel 2003.

 

[LTJ]

No haven't found the solution.
Gave the problem to an expert but haven't heard from him.