How do I change colors on the row/column active header?

G

Guest

When active I've seen the row and column header buttons a different color
than the rest of the header buttons. How do I turn on this feature? Right
now the buttons become bold but I'v eseen the entire button go from grey to
blue.
 
G

Gord Dibben

If you select any cell the row and column headers for that cell will turn color.

If you select a row or column header that header will turn black.

This is default behaviour for versions <2007.

I do not have 2007 so can't speak for that.


Gord Dibben MS Excel MVP
 
G

Guest

Well if by default that is supposed to be the case then somehow mine got
turned off. Any idea on how to turn it back on?
 
G

Gord Dibben

What version?

I have heard that version 2007 has very weak highlighting colors.

Otherwise, there is no magic button or option to turn the default behaviour back
on.

What color scheme are you using in Desktop>Properties>Appearance?

Maybe make a change there.

I use the Windows Classic Theme and Windows Standard Color Scheme which gives me
gray headers that turn to blue when a cell is selected.


Gord
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

when I activate a cell i change color of active row & header from 2
How to set highlight for the column&row header of the active cell 1
RGB for column and row headers colors in Excel 2007 4
How do I change the color of the indicator cell in row and column 1
How do I highlight the active row and column headers? 2
Active Row & Column header is white in Excel 2003 2
How do I turn off header and footer in 2007? 1
Change the properties of the worksheet row or column header bars 6

Top