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

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
"LTJ" wrote in message
...
| 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

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

"Jim Rech" wrote:

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
"LTJ" wrote in message
...
| 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

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.
--
LTJ


"Bob Umlas, Excel MVP" wrote:

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

"Jim Rech" wrote:

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
"LTJ" wrote in message
...
| 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

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

"LTJ" wrote:

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

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


"Quizzy53" wrote:

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

"LTJ" wrote:

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