Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
search for multiple strings | Excel Discussion (Misc queries) | |||
Trying to search an Array of Strings | Excel Programming | |||
Search two Strings | Excel Programming | |||
Search for strings | New Users to Excel | |||
VBA search and compare strings | Excel Programming |