Excel Search Entire Workbook
August 28, 2014 - by Bill Jelen
You need to find something, but you don’t know what worksheet it is on.

- Display Find with Ctrl + F
- Click the Options > > button.
- Open the Search dropdown and change from Sheet to Workbook.
This is one of the tips in Learn Excel 2007-2010 from MrExcel – 512 Excel Mysteries Solved.