Search for strings

[SANTANDER]

does anybody know simple and correct way search for key word (or strings,
like AKL-35, etc) in Excel workbook that have multiple worksheets. Key word
can be in any place inside spreadheets. Without messing with macro ar smth
else, just search, fast and simple.

 

[Rick Rothstein \(MVP - VB\)]

How about using Edit/Find from Excel's menu bar? Just make sure you click
the Option>> button to reveal all the possible options and select Workbook
from the "Within" dropdown. Finish by clicking the Find All button.

Rick

 

[SANTANDER]

Really, this work well. Just not sure how better set the other options
available:
Search: by Rows/ by Columns
Look in: Formulas/Values/Comments
and checkboxes 'Match case', 'Match entire cell contents'.
Or this does not matter in this case?

Thanks.