| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
How do I use "find" to search whole workbook?
I can get it to search for items on one sheet but I need to look through the
whole notebook. |
|
#2
|
|||
|
|||
|
What excel version are you using?
97 had a bug using find across worksheets otherwise just group the sheets before you do the find (click one sheet, hold down shift and click the last sheet or hold down ctrl and select each sheet you want to include) Regards, Peo Sjoblom "Sholtzy" wrote: I can get it to search for items on one sheet but I need to look through the whole notebook. |
|
#3
|
|||
|
|||
|
try Jan Karel Pieterse's FlexFind.
You can find it he http://www.oaltd.co.uk/MVP/ It'll work with all versions. Sholtzy wrote: I can get it to search for items on one sheet but I need to look through the whole notebook. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel has a "Find Next" command but no "Find Previous" command. | Excel Discussion (Misc queries) | |||
| copy a workbook from other workbook with lot of sheets wit... | Excel Discussion (Misc queries) | |||
| Creating a subbook from a workbook. | Excel Discussion (Misc queries) | |||
| Stubborn toolbars in Excel | Excel Discussion (Misc queries) | |||
| "Find" in workbook | Excel Discussion (Misc queries) | |||
Hybrid Mode
