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

K

Kitty

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?
 
P

Peo Sjoblom

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
 
R

Ron de Bruin

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