find in multi

A

amr

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

Ron@Buy

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MULTI 2
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
correct syntax for nesting "if", "and", and "vlookup"....if possib 4
Convert multiple series into single series 0
VLookup 5
How break column formatting to vary cell widths vertically? 1
Search adjacent cells in Column for sequence 3
change cells contents from vertical to horizontal 2

Top