Excel won't highlight selected cells

[David K.]

Hi. Just started having a problem today with selecting cells. I have
worksheets that need to have the formatting changed on certain cells. Some
need to be merged, some need to have different fonts, etc.

Before today, I was able to hold the CTRL key down and select whatever cells
needed to be changed (as a group). I can still do that, but only the Title
row and columns (A,B,C...1,2,3,4...) are highlighted but not the individual
cells that I have clicked on.

The problem is more of a large annoyance and I can still get my work done
but it takes much longer because I can't easily see what cells I have
selected. I have a looming deadline and need every second in order to
complete the project.

Does this make any sense to anyone or do I need to explain it better?
Anyone know how to fix this?

Thanks,

David K.

 

[Mike H]

David,

AFAIK there is no inbuilt way to change/remove the highlight colour of a
selected cell(s) and because the row/col headers are still highlighting then
I don't believe this is happening in your case.

Have you tried changing the contrast on the monitor. Users often complain;
particularly about E2007, that the highlighting is too feint.
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.

 

[Gord Dibben]

David

If you want a permanent fix for the selected cells coloring in Excel 2007
here is a Registry hack.

Start>Run regededit.exe

Drill down to

HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Options

Right-click on Options6 and Modify>Decimal........change the 32 to 16

When you select multiple cells all but the active cell will be black.


Gord Dibben MS Excel MVP