searching

[Joanne]

Win XPPro, Office 2003
I want to use either Ctrl+F or set up a parameter query to search my
spreadsheet.
My question is how do I tell excel to search the entire workbook, not
just the active sheet?
Thanks for your help from this inexperienced user
Joanne

 

[Bill Kuunders]

select all the sheets first
click on the first sheet hold shift and click onto the last sheet
then do the <cntr>F

 

[Joanne]

Thank you, thank you Bill

 

[Joanne]

Thank you, thank you Bill
Joanne

 

[Guest]

You can also use Options > Within: Workbook to do the same thing without the
danger of selecting all worksheets.