Yep, if they are not highlighted, I guess they would be hard to see.<g

Seriously, though, I presume you are clicking the Find All button to find
all of the cells matching your search condition. After you have done that,
press Ctrl+A to select all of the cells. You can now Close the dialog box
and the cells will remain selected.

Rick


"Shelly" wrote in message
...
I use the "find" function to search for words in an excel spreadsheet and
when the results are shown, the cell on the spreadsheet is not highlighted
and it is hard to see. Any way to change the formatting so that the cells
that match the find results are hi-lighted?

Thanks.