<ctrl f> (find) for all worksheets at once?

[mortgageman]

When I bring up the built in find (using ctrl and f at the same time) it only searches in the worksheet that I am currently in. Is there an option to search all of the worksheets?

Gene Klein

 

[Jonmo1]

Yes,

In the find window, under options

Change Within to WorkBook


Hope that helps.

 

[mortgageman]

Yes,

In the find window, under options

Change Within to WorkBook


Hope that helps.

It worked (and helped) perfectly.

Thank you

 

[mortgageman]

It worked (and helped) perfectly.

Thank you

Actually - is there an option for only certain worksheets?

Gene Klein

 

[mortgageman]

Actually - is there an option for only certain worksheets?

Gene Klein

bmp