search for word/number in excel workbook utilizing all tabs

[elaine]

In excel workbook, and using the tabs on the bottom can I search through all
tabs for a specific word/or number without searching each tab?

 

[Bart Snel]

Yes, using the search option: workbook instead of sheet.

Bart Snel

 

[N Harkawat]

Select the right most tab
Pressing the shift key now select the left most tab
This way all tabs are selected.
Now do your search
It will searchj all the sheets

 

[patrick]

Right click>select all sheets>Ctrl+f>find next
Pat F

 

[Pank Mehta]

You could try using ASAP Utilities as an Add-in, it has some other great
thinhs as well.

It is available free at www.asap-utilities.com