excel worksheet search

[raphael hirsch]

In microsoft excel for OSX, how do I search all worksheets in a file?
Using the find command I am only able to search the worksheet that is
active.

 

[J.E. McGimpsey]

In microsoft excel for OSX, how do I search all worksheets in a file?
Using the find command I am only able to search the worksheet that is
active.

Group the sheets (select the left-most sheet and Shift-click on the
tab of the rightmost sheet), then do your find.

Remember to ungroup the sheets once you're done searching -
otherwise any change you make to the active sheet will be made to
all the others as well.

 

[Bernard Rey]

J.E. McGimpsey wrote :

Group the sheets (select the left-most sheet and Shift-click on the
tab of the rightmost sheet), then do your find.

Remember to ungroup the sheets once you're done searching -
otherwise any change you make to the active sheet will be made to
all the others as well.

Curiouly enough, once it has found one occurrence of the string, it sticks
on the same sheet, even if there are some more occurrences to be found on
other sheets. Let's say we have three sheets. On the "Sheet2" the string
"hello" in cells B4, B5, B6, on "Sheet3" the same string "hello" in cell B3.

Now if you select "Sheet1", hold the Shift key and click the "Sheet3" tab
(thus selecting the three as a Workgroup), strike "Command-F" and type
"hello" in the search field: the cell B3 on "Sheet3" wil be highlighted, but
you can strike "Command-G" as much as you like, you'll never get to the
"Sheet2". Strange isn't it? Or is it just me?

 

[J.E. McGimpsey]

Strange isn't it? Or is it just me?

Not just you. Frankly, I forgot about Find Next.

A while ago I wrote a macro to search all sheets with Find Next. It
may be a bit overkill (and I'd probably write it differently for
general use), but here it is:


http://google.com/groups?threadm=arjf-AD823D.23184830112001@msnews.
microsoft.com