How to search whole Workbook for a string ?

[@Kumar157@]

Hi All,

It's my first post in Chandoo forums. Hope I will learn more and more going forward interacting with the forum members across the globe.

I knew the command CTRL + F to search a single worksheet in any workbook. But When I have multiple worksheets in a Workbooks, Searching one after another manually is tiresome.

Is there any trick for this ??

 

[chirayu]

After clicking CTRL + F, in the popup click on "Options" & change "Sheet" to "Workbook" from the dropdown

 

[@Kumar157@]

Yes, It's working. Thank you.