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?

Here are two ways...

1) Group the sheets before using the Find command. To group sheets, click on
the tab of the first sheet, then click on additional sheet tabs while holding
down the Ctrl key. Or, click on the first sheet tab, then click on the sheet
tab furthest from that sheet while holding down the Shift key.

2) In the Find and replace dialog, click the Options button on the Find tab.
Change the 'Within' box option to Workbook.

Hope this helps,

Hutch

"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?

Depends upon version.

Earlier versions had no search entire workbook option.

Versions from 2002 onward(maybe 2000 also) have a search within the workbook
option.


Gord Dibben MS Excel MVP

On Tue, 8 Jul 2008 14:02:04 -0700, 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?

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?