Hi Fred,

From the Home tab, Editing group, left click on Find & Select.
Then left click on Find to display the Find and Replace dialog box
In the Find and Replace dialog box, in the Find tab, select Workbook from
the "Within" drop down list.

Thanks,
Peggy

"BIG FRED" wrote:

I have a spreadsheet that has several sheets, When I do a search function I
need to search all sheets not just the active one. How do I do this?