serach multiple worksheets within a workbook

G

Guest

Is it possible to search for information in multiple
worksheets within a workbook at the same time rather going
into the individual tabs and using ctrl-F.

Could you advise please?
 
B

bigt

Sure - just click Edit, Find, and select Workbook instead
of the default Worksheet in the "within" box. You can find
all, or next, or find and replace whatever you're
searching for.
 

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

EXCEL 2
How do I move multiple tabs in multiple workbooks to a master? 3
Auto update worksheets 2
How do I find like data in multiple worksheets? 1
Worksheets with password protection 4
Multiple Worksheet Find 2
view 2 different worksheets within the Wrkbk 7
Totaling cells in multiple worksheets 4

Top