Search highlighted section in calc? [closed]

Hello.
I would like to be able to search a specified section of a spreadsheet in calc, however when I highlight the section, enter the word/number I am searching for in the search bar, then hit enter, the search ignores the part I have selected and simply shows me the first instance of that word/number (from left to right/top to bottom, like reading a book).