Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|