Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Singhu
 
Posts: n/a
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default 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
  #3   Report Post  
Posted to microsoft.public.excel.misc
Nick Hodge
 
Posts: n/a
Default 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?



  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 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?




  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default 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?






  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I delete the drop down list of header / footer options in e Progress Finance Excel Discussion (Misc queries) 1 December 1st 05 06:49 PM
header and footer problems cliffhanger79 Charts and Charting in Excel 4 November 7th 05 08:03 PM
Header & Footer Excel 2003 juliasl0 Excel Discussion (Misc queries) 2 November 4th 05 02:37 PM
How to reference a text cell that changes weekly in Header or Foo. duane Excel Discussion (Misc queries) 2 March 20th 05 02:31 PM
How to insert a picture in the Footer (not the Header) in Excel 20 jmon Excel Worksheet Functions 2 March 17th 05 05:59 AM


All times are GMT +1. The time now is 02:04 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"