Change font colors in the header of an excel document?

  • Thread starter Thread starter Andrew
  • Start date Start date
A

Andrew

I've been reading that it is not possible to change font colors of headers
and footers in Excel. Is this true? Is there a way around it?
 
I don't know about office 2007 but as far earlier versions are concerned, you
can certainly change font colors of headers and footers in Excel.

To do that, click on file - page setup - Header/Footer pane - Custom Header
or Custom Footer - select proper pane (left/centre/right) - before entering
text, click on first icon [A] just above, format as per your choice and do
the rest.

learn - n - enjoy
 
YESHWANT

Where exactly do you see a color selection on the Font format dialog after
clicking [A] in earlier versions?


Gord Dibben MS Excel MVP

I don't know about office 2007 but as far earlier versions are concerned, you
can certainly change font colors of headers and footers in Excel.

To do that, click on file - page setup - Header/Footer pane - Custom Header
or Custom Footer - select proper pane (left/centre/right) - before entering
text, click on first icon [A] just above, format as per your choice and do
the rest.

learn - n - enjoy
---------------------------------------
click yes below, if it works for you


Andrew said:
I've been reading that it is not possible to change font colors of headers
and footers in Excel. Is this true? Is there a way around it?
Click to expand...
Click to expand...
 
Hi Gord and Andrew,
: Where exactly do you see a color selection on the Font format dialog after clicking [A] in earlier versions?
Click to expand...

SORRY. I thought it is colour of the font, but it is underline option.

learn - n - enjoy
---------------------------------------

Gord Dibben said:
YESHWANT

Where exactly do you see a color selection on the Font format dialog after
clicking [A] in earlier versions?


Gord Dibben MS Excel MVP

I don't know about office 2007 but as far earlier versions are concerned, you
can certainly change font colors of headers and footers in Excel.

To do that, click on file - page setup - Header/Footer pane - Custom Header
or Custom Footer - select proper pane (left/centre/right) - before entering
text, click on first icon [A] just above, format as per your choice and do
the rest.

learn - n - enjoy
---------------------------------------
click yes below, if it works for you


Andrew said:
I've been reading that it is not possible to change font colors of headers
and footers in Excel. Is this true? Is there a way around it?
Click to expand...
Click to expand...
Click to expand...
 
No problem.

Just thought I had missed something which is now avilable in 2007 version.


Gord

Hi Gord and Andrew,
: Where exactly do you see a color selection on the Font format dialog after clicking [A] in earlier versions?
Click to expand...

SORRY. I thought it is colour of the font, but it is underline option.

learn - n - enjoy
---------------------------------------

Gord Dibben said:
YESHWANT

Where exactly do you see a color selection on the Font format dialog after
clicking [A] in earlier versions?


Gord Dibben MS Excel MVP

I don't know about office 2007 but as far earlier versions are concerned, you
can certainly change font colors of headers and footers in Excel.

To do that, click on file - page setup - Header/Footer pane - Custom Header
or Custom Footer - select proper pane (left/centre/right) - before entering
text, click on first icon [A] just above, format as per your choice and do
the rest.

learn - n - enjoy
---------------------------------------
click yes below, if it works for you


:

I've been reading that it is not possible to change font colors of headers
and footers in Excel. Is this true? Is there a way around it?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top