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

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


"Kitty" wrote in message
...
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?

When you use 2002 or 2003 you have a option in Ctrl-f
click on options and change Within to Workbook

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Peo Sjoblom" wrote in message ...
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


"Kitty" wrote in message
...
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?