- Mar 10, 2002
Would someone explain how the Edit/Find command works with a group of worksheets selected. For instance, I have six worksheets selected, and I know the word "DATE" is on all of them. When I use "Edit/Find" and search for the word "DATE", it finds the word on the active sheet only. However if I search for the word "TEST" which I know is only on sheet3, (I'm starting my search from sheet1 each time), It jumps to sheet3 and finds the word "TEST". My question: Is there a way to search for each instance of a word on each sheet without selecting each sheet one at a time?