searching

  • Thread starter Thread starter Joanne
  • Start date Start date
J

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
 
select all the sheets first
click on the first sheet hold shift and click onto the last sheet
then do the <cntr>F
 
You can also use Options > Within: Workbook to do the same thing without the
danger of selecting all worksheets.
 
Back
Top