MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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.

Excel Search Entire Workbook
Excel Search Entire Workbook
  • 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.