Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sorting
Is there a way to search an entire workbook for keywords and return the
entire row? The same as "sort" does on one page, just across the whole workbook. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
sorting
Right-click on a sheet tab and select "Select All Sheets", then a regular
Find command will search thru all the sheets. Not sure what you mean by "return the entire row", tho. "Still Learning" wrote: Is there a way to search an entire workbook for keywords and return the entire row? The same as "sort" does on one page, just across the whole workbook. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
sorting
Sort does not search.
Did you mean same as Filter? You cannot filter across worksheets You can search across sheets in a workbook. What is "entire row" and to where you like your found data returned? Gord Dibben MS Excel MVP On Tue, 4 May 2010 12:09:01 -0700, Still Learning wrote: Is there a way to search an entire workbook for keywords and return the entire row? The same as "sort" does on one page, just across the whole workbook. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting Values Without Sorting Formulas | Excel Discussion (Misc queries) | |||
Automatic sorting (giving max and min) based on custom sorting lis | Excel Worksheet Functions | |||
Sorting VLookup vs Sorting SumProduct | Excel Discussion (Misc queries) | |||
Sorting: Sorting by the First Character | Excel Discussion (Misc queries) | |||
Sorting | Excel Discussion (Misc queries) |