Multiple Worksheet Find
You say you have "7 of them open at the same time" so I assume you mean 7
workbooks.
There is no function to search across multiple open workbooks.
You can search across worksheets in a single workbook.
I don't know of any way to default the "search in" to workbook.
Just right-click on a sheet tab and "Select all sheets" then do your search.
Gord Dibben MS Excel MVP
On Mon, 1 Oct 2007 15:51:03 -0700, NealMed
wrote:
I want to know if it's possible to have a function that allows us to search
multiple Worksheets with minimum commands. You obviously use the CTRL - F, to
search a sheet or workbook, but we have 7 of them open at a time, that we
would like to search for data in.
The other part of that is, Is it possible to default the CTRL - F function
to default to search Workbook?
|