Searching in Excel spreadsheet

[Tohvie]

Is there a way to change the shading of the found cell? When I do search, I
cannot see the cell found as it is not shaded or distinguished in any way
from the other cells. I have looked around but cannot find an option to
change it so that I can actually see the result.

 

[trip_to_tokyo]

Before you start your search click on the cell to the left of A and above 1
in the top left hand corner of the Worksheet.

This should highlight the whole Worksheet.

Now, when you do your search, your results will be much more clearly
identified.

If my comments have helped please hit Yes.

Thanks.

 

[Gord Dibben]

One trick you can use, especially when you have multiple found items.

After you have hit the "Find" or "Find All"

With cursor in the "Found" dialog box, hit CTRL + a to select whatever cells
have been found.

Then hit the color picker Icon and select a color for the found cells.

OR...............

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