Find does search in the whole Sheet (or workbook if you so desire). It starts
forward from the current position but it starts from the top after reaching
the end). There is a FIND ALL option too which you can use to see ALL
occurences of the search term.

You can also search by Rows, by Columns,... and much more.

Am I missing something in your post?

"Freek Versteijn" wrote:

Dear MS Excel team

I have a fundamental suggestion for the Find feature in Excel. When I open
an Excel sheet it is shown in it's last state. That is also true when I
downloaded it. This is a good feature, but it's the start of my example for
the weaker Find feature that my suggestion is about.

It seems that the Find feature searches the Excel sheet starting at the
selected cell. Somewhat like the Find feature in Word starts searching from
the cursor position, which is only logical. But an Excel sheet is no Word
document. It doesn't make sense to start the search from the cursor position
(selected cell) in this case because I think that the search term in Excel is
often a unique one and not one that is (meant to be) found a lot of times in
the 'document' like in Word. Searching from the selected cell would narrow
the chance of finding the search term, which for me is often the case while I
know that the term exists in the sheet but in a somewhat higher located cell
than the one selected.
I find this feature weak because it forces me to select cell A1 every time
before starting a search that actually searches the whole sheet. From a
usability perspective this is also poor because this behaviour can only be
discovered by knowing that the search term is actually in the document, while
that is often not the case when searching....

Think about it.

Kind regards,


David van Leerdam

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

https://www.microsoft.com/office/com...lic.excel.misc