Find utility, highlighting answer


Phil C

In the older version of Excel when I used the find utility it would highlight
the cells found in a different shade.

When I use the same utility in Excel 2007 the highlighting is bearly
visable, so I cannot see what I searched for.

Is there a way I can change this so the highlighted result is more visable ?.


Hi Phil, I don't think there is.

What I do to get around the problem that you have identified is, before I
start the search, highlight all the cells in the Worsheet (by clicking on
cell to the left of A and above 1 towards the top left hand corner) then I do
Ctrl-F: that way the cells that you are looking for are much more clearly

If my comments have helped please hit Yes.


Gord Dibben

After running the "Find All", hit CTRL + a to select all cells in the
"Found" dialog box.

Then hit your colorpicker to color the cells darker.

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


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

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