Find (Ctrl +F) not searching all open sheets

G

Guest

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

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)
 
G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple Worksheet Find 2
Find Function behaving differently in different spreadsheets 1
Cannot get previous data after ctrl + w 0
how do i make a cell a search cell for a spreadsheet 5
Ctrl F 3
Macro to Find & Replace 2
macro on different reports CTRL+F in formula 2
Reset the macro assigned to Ctrl+F on workbook deactivate 11

Top