Find (Ctrl +F) not searching all open sheets

[Caroline]

I have Excel 2003 and would like to search (Ctrl+F)through all open sheets at
one time. A coworker can do this. Is there a patch?

[Peo Sjoblom]

What do you mean by all open sheets? If you want so search through a
workbook you need to group all sheets (select all sheets)

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



"Caroline" <Caroline@discussions.microsoft.com> wrote in message
news:67CA5BE3-34C5-4DDD-86C3-9CDE24212290@microsoft.com...
>I have Excel 2003 and would like to search (Ctrl+F)through all open sheets
>at
> one time. A coworker can do this. Is there a patch?

[Gord Dibben]

Caroline

Excel 2002 and 2003 have an option to find in Sheet or across entire workbook.

Edit>Find>Options>Within.


Gord Dibben Excel MVP

On Fri, 21 Jan 2005 18:29:01 -0800, "Caroline"
<Caroline@discussions.microsoft.com> wrote:

>I have Excel 2003 and would like to search (Ctrl+F)through all open sheets at
>one time. A coworker can do this. Is there a patch?