Goto 'Find & Replace' type in what you wish to find. Then 'Options' button
Change the 'Within' field to Workbook and click on OK.
Hope this helps

"amr" wrote:

Friends i have 9 excel worksheets and i arranged its in a vertical view
so i want to search in them all one time