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.