Search for strings
 

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.

Search for strings
 

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" wrote in message
...
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.

Search for strings
 

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.


"Rick Rothstein (MVP - VB)" wrote in
message ...
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" wrote in message
...
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.