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

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

--
Greetings from New Zealand


"Joanne" wrote in message
...
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

Thank you, thank you Bill
Joanne

Bill Kuunders wrote:

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

Thank you, thank you Bill

Bill Kuunders wrote:

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

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

"Joanne" wrote:

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