header with colored background

[Luc Benninger]

Hi,
is it possible to make a header that has a background color? I tried to
achieve this by inserting a picture but the picture never covered the whole
page width. Any hints?
Thanks, Luc

 

[David McRitchie]

Hi Luc,
You would have to use the top rows as your header, and if you
wanted a logo only on the first page that is possible by making
the rows to repeat at top start lower. Additional details in
Logos and Graphics into headers/footers
http://www.mvps.org/dmcritchie/excel/logoshd.htm

 

[David McRitchie]

Hi Luc,
I assumed you meant cover the entire width of the page for
background color since your were talking about header.

If you meant to have a picture in the background that would be called a
watermark which you can find some links for my xlindex.htm page.

If it is a logo that runs across the top of the page you would have to lock
the picture to the cell boundaries -- right click on border of picture,
format picture, properties, move and resize with cells.
---
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

Hi Luc,
You would have to use the top rows as your header, and if you
wanted a logo only on the first page that is possible by making
the rows to repeat at top start lower. Additional details in
Logos and Graphics into headers/footers
http://www.mvps.org/dmcritchie/excel/logoshd.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

is it possible to make a header that has a background color? I tried to
achieve this by inserting a picture but the picture never covered the whole
page width. Any hints?