sorting

S

Still Learning

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.
 
B

Bob Umlas, Excel MVP

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.
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filtering 1
How to sort entire spreadsheet by one column sort 5
Indenting every other paragraph in Word at the same time? 0
Footnote references on one page, footnote text on the next 5
Linking Rows Between Sheets When Sorting 1
Removing Line Numbers 4
Sharing workbooks limitations - Merged Cells 12
Sorting sections or group sections 1

Top