Color Header printing B&W

W

Wendy

I am using Excel 2002. I am placing a color logo in the
header, but it will not preview or print in color even
when the rest of the document does. Any advise?

Thanks for the help!
 
N

Norman Harker

Hi Wendy!

I saw this Yesterday and watched for an answer. None!

So off to Google and Help (As a last resort <g>)

Extract from Help:
Note You cannot change the color of header and footer text. I think
that will go for inserted graphics as well.

Maybe you could achieve what you want on the workbook itself rather
than in the header and footers.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
G

Gord Dibben

Wendy/Norman

With XL2002.......

Custom Header>Insert Picture button>go find the picture to insert and
double-click on it.

Edit Picture(right of Insert Picture button). You can edit the size and color
of the picture. Make sure Color is set to "Automatic".

Prints color graphic as Header.

Gord Dibben Excel MVP
 
N

Norman Harker

Hi Gord!

That's useful. Didn't come up in Help or a quick Google.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
W

Wendy

Gord,
I tried that and it still isn't working. I have already
set the printer for this document to the color printer,
and as I stated previously the rest of the document does
print color...only the header does not. Any other ideas?

Wendy~
 
G

Gord Dibben

Wendy

I have no problem showing or printing a colored graphic in a header or footer
using XL2002.

I'm not sure why you are experiencing difficulty.
That is the way that Excel treats headers and footers.
Click to expand...
Prior to XL2002 only.

With XL2002.......

Custom Header>Insert Picture button>go find the picture/logo to insert and
double-click on it.

Edit Picture(right of Insert Picture button). You can edit the size and color
of the picture. Make sure Color is set to "Automatic".

Shows in color in Print Preview and Prints color graphic as Header.

Gord Dibben Excel MVP

Here is an answer I provided to your question in excel.setup

Hi Wendy,
That is the way that Excel treats headers and footers.

For the header you can use the first row(s) for a header
and include color logos and include fonts with color.

More information in
Logos and Graphics into headers/footers
http://www.mvps.org/dmcritchie/excel/logoshd.htm

Headings for Columns, and Page Numbering
http://www.mvps.org/dmcritchie/excel/headcols.htm

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Wendy said:
I am using Excel 2002. I am placing a color logo in the
header, but it will not preview or print in color even
when the rest of the document does. Any advise?

Thanks for the help!
Click to expand...
Click to expand...
 
G

Gord Dibben

Wendy

Correction to my post.

You cannot "edit" the color. You can only alter which mode it prints out.

Picture Tab>Color>Automatic, gray scale, black and white, washout.

Gord

Wendy

I have no problem showing or printing a colored graphic in a header or footer
using XL2002.

I'm not sure why you are experiencing difficulty.
That is the way that Excel treats headers and footers.
Click to expand...
Prior to XL2002 only.

With XL2002.......

Custom Header>Insert Picture button>go find the picture/logo to insert and
double-click on it.

Edit Picture(right of Insert Picture button). You can edit the size and color
of the picture. Make sure Color is set to "Automatic".

Shows in color in Print Preview and Prints color graphic as Header.

Gord Dibben Excel MVP

Here is an answer I provided to your question in excel.setup

Hi Wendy,
That is the way that Excel treats headers and footers.

For the header you can use the first row(s) for a header
and include color logos and include fonts with color.

More information in
Logos and Graphics into headers/footers
http://www.mvps.org/dmcritchie/excel/logoshd.htm

Headings for Columns, and Page Numbering
http://www.mvps.org/dmcritchie/excel/headcols.htm

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Wendy said:
I am using Excel 2002. I am placing a color logo in the
header, but it will not preview or print in color even
when the rest of the document does. Any advise?

Thanks for the help!
Click to expand...
Click to expand...
Click to expand...
 
D

David McRitchie

I'd forgotten that Excel 2002 could do color in headers and footers.

While searching for color in headers and footers to see if Excel 2002
really did support color in headings and footings, I found it interesting
that the much older Excel 3 supported color.
Q95478 - Can't Print Color Headers and Footers (in Excel 2000)
http://support.microsoft.com/?kbid=95478


Wendy

Correction to my post.

You cannot "edit" the color. You can only alter which mode it prints out.

Picture Tab>Color>Automatic, gray scale, black and white, washout.

Gord

Wendy

I have no problem showing or printing a colored graphic in a header or footer
using XL2002.

I'm not sure why you are experiencing difficulty.
That is the way that Excel treats headers and footers.
Click to expand...
Prior to XL2002 only.

With XL2002.......

Custom Header>Insert Picture button>go find the picture/logo to insert and
double-click on it.

Edit Picture(right of Insert Picture button). You can edit the size and color
of the picture. Make sure Color is set to "Automatic".

Shows in color in Print Preview and Prints color graphic as Header.

Gord Dibben Excel MVP

Here is an answer I provided to your question in excel.setup

Hi Wendy,
That is the way that Excel treats headers and footers.

For the header you can use the first row(s) for a header
and include color logos and include fonts with color.

More information in
Logos and Graphics into headers/footers
http://www.mvps.org/dmcritchie/excel/logoshd.htm

Headings for Columns, and Page Numbering
http://www.mvps.org/dmcritchie/excel/headcols.htm

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

I am using Excel 2002. I am placing a color logo in the
header, but it will not preview or print in color even
when the rest of the document does. Any advise?

Thanks for the help!
Click to expand...
Click to expand...
Click to expand...
 
G

Gord Dibben

David

Excel 3.0! Interesting for sure. After about 8 revisions we have come full
circle. Well, not quite full......can't format Font Color in XL2002.

Gord


I'd forgotten that Excel 2002 could do color in headers and footers.

While searching for color in headers and footers to see if Excel 2002
really did support color in headings and footings, I found it interesting
that the much older Excel 3 supported color.
Q95478 - Can't Print Color Headers and Footers (in Excel 2000)
http://support.microsoft.com/?kbid=95478


Wendy

Correction to my post.

You cannot "edit" the color. You can only alter which mode it prints out.

Picture Tab>Color>Automatic, gray scale, black and white, washout.

Gord

Wendy

I have no problem showing or printing a colored graphic in a header or footer
using XL2002.

I'm not sure why you are experiencing difficulty.

That is the way that Excel treats headers and footers.
Prior to XL2002 only.

With XL2002.......

Custom Header>Insert Picture button>go find the picture/logo to insert and
double-click on it.

Edit Picture(right of Insert Picture button). You can edit the size and color
of the picture. Make sure Color is set to "Automatic".

Shows in color in Print Preview and Prints color graphic as Header.

Gord Dibben Excel MVP

Here is an answer I provided to your question in excel.setup

Hi Wendy,
That is the way that Excel treats headers and footers.

For the header you can use the first row(s) for a header
and include color logos and include fonts with color.

More information in
Logos and Graphics into headers/footers
http://www.mvps.org/dmcritchie/excel/logoshd.htm

Headings for Columns, and Page Numbering
http://www.mvps.org/dmcritchie/excel/headcols.htm

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

I am using Excel 2002. I am placing a color logo in the
header, but it will not preview or print in color even
when the rest of the document does. Any advise?

Thanks for the help!
Click to expand...
Click to expand...
Click to expand...
 
W

Wendy

Gord,
I have made sure the color is set to "Automatic", I am not
looking for the text to print in color, only the picture.
It is a color graphic and shows as color until I look at
the print preview. Other documents with different color
headers print fine, just not this one...any ideas? Is it
time to recreate the document?

Wendy
-----Original Message-----
Wendy

Correction to my post.

You cannot "edit" the color. You can only alter which mode it prints out.

Picture Tab>Color>Automatic, gray scale, black and white, washout.

Gord

Wendy

I have no problem showing or printing a colored graphic in a header or footer
using XL2002.

I'm not sure why you are experiencing difficulty.
That is the way that Excel treats headers and footers.
Click to expand...
Prior to XL2002 only.

With XL2002.......

Custom Header>Insert Picture button>go find the picture/logo to insert and
double-click on it.

Edit Picture(right of Insert Picture button). You can edit the size and color
of the picture. Make sure Color is set to "Automatic".

Shows in color in Print Preview and Prints color graphic as Header.

Gord Dibben Excel MVP

Here is an answer I provided to your question in excel.setup

Hi Wendy,
That is the way that Excel treats headers and footers.

For the header you can use the first row(s) for a header
and include color logos and include fonts with color.

More information in
Logos and Graphics into headers/footers
http://www.mvps.org/dmcritchie/excel/logoshd.htm

Headings for Columns, and Page Numbering
http://www.mvps.org/dmcritchie/excel/headcols.htm

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

I am using Excel 2002. I am placing a color logo in the
header, but it will not preview or print in color even
when the rest of the document does. Any advise?

Thanks for the help!
Click to expand...
Click to expand...

.
Click to expand...
 
Top