If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|