serach multiple worksheets within a workbook

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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
Multiple Worksheet Find 2
How do I move multiple tabs in multiple workbooks to a master? 3
combine multiple spreadsheets into one workbook 1
How do I find like data in multiple worksheets? 1
Auto update worksheets 2
view 2 different worksheets within the Wrkbk 7
Aggregating data among multiple workbooks 1

Back
Top