Home |
Search |
Today's Posts |
#1
|
|||
|
|||
search for word/number in excel workbook utilizing all tabs
In excel workbook, and using the tabs on the bottom can I search through all
tabs for a specific word/or number without searching each tab? |
#2
|
|||
|
|||
Yes, using the search option: workbook instead of sheet.
Bart Snel "elaine" schreef in bericht ... In excel workbook, and using the tabs on the bottom can I search through all tabs for a specific word/or number without searching each tab? |
#3
|
|||
|
|||
Select the right most tab
Pressing the shift key now select the left most tab This way all tabs are selected. Now do your search It will searchj all the sheets "elaine" wrote in message ... In excel workbook, and using the tabs on the bottom can I search through all tabs for a specific word/or number without searching each tab? |
#4
|
|||
|
|||
Right clickselect all sheetsCtrl+ffind next
Pat F "elaine" wrote: In excel workbook, and using the tabs on the bottom can I search through all tabs for a specific word/or number without searching each tab? |
#5
|
|||
|
|||
You could try using ASAP Utilities as an Add-in, it has some other great
thinhs as well. It is available free at www.asap-utilities.com "elaine" wrote: In excel workbook, and using the tabs on the bottom can I search through all tabs for a specific word/or number without searching each tab? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I change an excel template into a "workbook" | Excel Discussion (Misc queries) | |||
Automate Excel to powerpoint - Graphs along with Datasheet (not workbook) | Charts and Charting in Excel | |||
how to search in excel with condition | Excel Discussion (Misc queries) | |||
Can't open workbook (in Excel 2000) | Excel Discussion (Misc queries) | |||
Windows search in Excel with autofilter | Excel Discussion (Misc queries) |