How would you search an entire workbook with Find & Select?
On the Home tab, click Find & Select > Find > Options (Windows) or Find & Select > Find (Mac). Change the Search drop-down to All.
You cannot search an entire workbook - you must search the worksheets individually.
On the Home tab, click Find & Select > Find > Options (Windows) or Find & Select > Find (Mac). Change the Look in drop-down to Workbook.
On the Home tab, click Find & Select > Find > Options (Windows) or Find & Select > Find (Mac). Change the Within drop-down to Workbook.