Forum Discussion
Searching multiple worksheets for different numbers simultaneously in Excel
Is it possible to search multiple worksheets for different numbers simultaneously in Excel? Using CTL-F isn't working for me. For example, can I search 10 different worksheets all at once for t...
Using CTRL+F:
Goto the "Options" and change the scope to "Within Workbook".
Notes:
The search is always in the complete workbook.
The settings will remain until changed.
You can only search for one number at the time.