From the Edit menu, choose "Find", click the "Options" button to extend the
dialogbox to show the advanced options.

In the "Within" dropdown list, choose "Workbook".

Regards,
Edwin Tam

http://www.vonixx.com




"Karline" wrote:

I am trying to find data that could be on any of the sheets in my excel work
book is there a way of searchind all sheets at once?