Searching in Excel spreadsheet
 

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.

Searching in Excel spreadsheet
 

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.

"Tohvie" wrote:

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.

Searching in Excel spreadsheet
 

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.

StartRun regededit.exe

Drill down to

HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\E xcel\Options

Right-click on Options6 and ModifyDecimal........change the 32 to 16

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


Gord Dibben MS Excel MVP

On Thu, 18 Mar 2010 10:29:01 -0700, Tohvie
wrote:

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.