how do i find data in multiple sheets in excel
 

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?

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?

Edwin's response will work with xl2002+.

But Jan Karel Pieterse's addin FlexFind:
http://www.oaltd.co.uk/MVP/

will work in all versions of xl.

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?

--

Dave Peterson