ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Changing the color of header and footer text (https://www.excelbanter.com/excel-discussion-misc-queries/60643-changing-color-header-footer-text.html)

Singhu

Changing the color of header and footer text
 
I would like to be able to make the header/footer a color other than black on
a simple datasheet (Excel 2000). Is there a simple way to do this?

Dave Peterson

Changing the color of header and footer text
 
I don't think that there is even a difficult way of doing this.

Maybe you could use rows to repeat at top (for the headers) instead??

Singhu wrote:

I would like to be able to make the header/footer a color other than black on
a simple datasheet (Excel 2000). Is there a simple way to do this?


--

Dave Peterson

Nick Hodge

Changing the color of header and footer text
 
Singhu

FilePage setup...Headers and footers tab and click on the 'A' button. The
font attributes are here

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Singhu" wrote in message
...
I would like to be able to make the header/footer a color other than black
on
a simple datasheet (Excel 2000). Is there a simple way to do this?




Steve K

Changing the color of header and footer text
 


"Nick Hodge" wrote:

Singhu

FilePage setup...Headers and footers tab and click on the 'A' button. The
font attributes are here

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Singhu" wrote in message
...
I would like to be able to make the header/footer a color other than black
on
a simple datasheet (Excel 2000). Is there a simple way to do this?





Steve K

Changing the color of header and footer text
 
Sorry Nick but that does not work (no option to change font colour), anybody
else got a suggestion?


"Nick Hodge" wrote:

Singhu

FilePage setup...Headers and footers tab and click on the 'A' button. The
font attributes are here

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Singhu" wrote in message
...
I would like to be able to make the header/footer a color other than black
on
a simple datasheet (Excel 2000). Is there a simple way to do this?





Dave Peterson

Changing the color of header and footer text
 
You can't change colors in headers/footers...well, at least through xl2003.

Maybe you can print the header/footer using a different application (MSWord???)
and then run the paper through the printer for the real data???

Or if you're using xl2002, you can add a picture to the header/footer. You
could create a picture of the text you want and then use that.

Steve K wrote:

Sorry Nick but that does not work (no option to change font colour), anybody
else got a suggestion?

"Nick Hodge" wrote:

Singhu

FilePage setup...Headers and footers tab and click on the 'A' button. The
font attributes are here

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Singhu" wrote in message
...
I would like to be able to make the header/footer a color other than black
on
a simple datasheet (Excel 2000). Is there a simple way to do this?





--

Dave Peterson


All times are GMT +1. The time now is 07:33 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com