Results 1 to 3 of 3

Thread: Restricting search

  1. #1

    Restricting search



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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.

  2. #2
    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
    Microsoft Excel Massive Open Online Course.
    Learn all about Microsoft excel in this Online course, with video tutorials, examples of applications and a complete functions and buttons explanation.
    Be part of our community and enjoy learning Excel.

  3. #3
    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".

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •