| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple Worksheet Find
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? -- NealMed |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Multiple Worksheet Find
Is the following something that could be useful? It has helped my scenario:
I was able to find and use a very simple solution to search all worksheets within a workbook. The users will be shown how to do this. For now this is an easy solution. Searching for a specific name in the Workbook within multiple worksheets: 1. Select Edit, Find 2. Within Find What €“ enter the last name eg.: Smith 3. Change Within cell to €śWorkbook€ť and check €śMatch Case€ť 4. Select Search €śBy Rows€ť 5. Click on Find All Item is found If name is not in Workbook, message is displayed advising this. "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? -- NealMed |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using the "Find" option across multiple tabs in one worksheet | Excel Discussion (Misc queries) | |||
| plot graph from multiple worksheet as embedded chart object on every worksheet | Charts and Charting in Excel | |||
| plot graph from multiple worksheet as embedded chart object on every worksheet | New Users to Excel | |||
| Upload multiple text files into 1 excel worksheet + put the filename as the first column in the worksheet | Excel Worksheet Functions | |||
| INTRICATE PROBLEM- How to find multiple text,excluding "H", in a multiple range of cells, then replacing 0 with another number in another cell | Excel Worksheet Functions | |||
Linear Mode
