Despite having used excel for years, I still have to ask this basic question. I noticed when using find in excel in very large spreadsheets that the system goes into “overdrive”. Instead of jumping to the next cell with the relevant value, it keeps searching for a long time. at times the find and replace box vanishes, then comes back with the counter in the top left still running through its searches.
I normally use find within sheet, search by rows and Look in Values as these seem to be the obvious criteria for looking for a name or address or a specific amount. Changing this to look in Formulas gets my results almost immediately but why should I use Formulas instead values in these cases?
