| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using the "Find" option across multiple tabs in one worksheet
In Excel, I have 144 tabs within the same worksheet. I need to use the Edit
Find option to find a specific product id within each worksheet. For an example, product ID: ABC. How can I use the "Find" option across all tabs at the same time? Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using the "Find" option across multiple tabs in one worksheet
Click Options, then change "Sheet" to "Workbook"
"prizm" wrote in message ... In Excel, I have 144 tabs within the same worksheet. I need to use the Edit Find option to find a specific product id within each worksheet. For an example, product ID: ABC. How can I use the "Find" option across all tabs at the same time? Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using the "Find" option across multiple tabs in one worksheet
You could also use Jan Karel Pieterse's FlexFind:
http://www.oaltd.co.uk/MVP/ (The feature that Bob suggested was added in xl2002, IIRC.) Bob Umlas wrote: Click Options, then change "Sheet" to "Workbook" "prizm" wrote in message ... In Excel, I have 144 tabs within the same worksheet. I need to use the Edit Find option to find a specific product id within each worksheet. For an example, product ID: ABC. How can I use the "Find" option across all tabs at the same time? Thanks -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 "Find" option won't work. | Excel Worksheet Functions | |||
| The worksheet option under "insert" is gray (unavailable)- why? | Excel Worksheet Functions | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| pictures to work with "data" "sort" option | Excel Discussion (Misc queries) | |||
| Disabling "SAVE AS" option under "File" | Excel Discussion (Misc queries) | |||
Linear Mode
