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