Change the properties of the worksheet row or column header bars

[FSHOTT]

Can someone tell me how to change the properties (backround color) of the
worksheet row or column header bars (i.e. the ROW 1,2,3 etc. or COLUMN
A,B,C,etc.? Thanks.....

 

[Bernard Liengme]

This is a Windows setting and will alter many things: right click you
desktop and open properties and experiment with Themes and Appearances
best wishes

 

[Shane Devenshire]

Hi,

You can't do that inside of Excel, so it's probably better not to. You can
change the default font under Tools, Options, General if that helps at all.

 

[FSHOTT]

Thanks for your response. I want to change background color not font so I am
still looking.

 

[FSHOTT]

Thank You for the response but this does not work for what I want to do. A
co-worker has this done on his computer but does not know how it was done and
I cannot seem to find it in the EXCEL buttons.

 

[emaichen]

select the relevant 'cell', 'row' or 'column', right click on it, go to
format cells, background and select the desired color


Regards
emaichen

 

[Gord Dibben]

The only way to change the background colors of row and column headings is
change the color scheme under Windows Appearance settings.

Which is a global setting and will affect all applications.


Gord Dibben MS Excel MVP