Restricting search

Hey.

I'm wondering if there is a way of blocking the contents of a certain range of cells from showing up when you do a ctrl + f search. E.g I have two cells in the same sheet with "test" in them. Can I block one of the cells so that when I search for Test it will only always return the one?

Cheers.

You can select only a range to search without the cell where you have the "test" that you don't want to find. You can create a range name in an easy way: Create a Range Name


www.excelmooc.com

But then I would have to select this range every time I did a search right? What I would be interested in is not selecting anything, just searching, and I could find it anywhere in the sheet except in the range of cells I want to "block".