Can I search the whole workbook and not just a sheet?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to search a large workbook for specific work order numbers, can I
do this or do I have to search each individual sheet?
 
You can search the whole workbook, select all sheets using click first, hold
down shift and click last sheet, then do the search
later don't forget to ungroup them or all changes made in one cell will be
done in all sheets

Regards,

Peo Sjoblom
 
When you use 2002 or 2003 you have a option in Ctrl-f
click on options and change Within to Workbook
 
You must log in or register to reply here.

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

Standard Deviation from one sheet to another 1
move worksheet to end of another workbook 3
Remove Filters from all sheets 10
Protecting a workbook 5
Excel Move or Copy Stopped Working? 0
Absolute Sheet Reference 3
How can I sort or search the sheet tabs? 3
How do I export a row of data into its own workbook 1

Back
Top