Filter by Cell Value is smart enough to identify and delete all rows containing a match to a list in another column. BUT I want to capture and keep them! (instead of deleting). If excel can identify them and delete them, it should also be able to identify and copy them to a clipboard. How do I make it do that?


If you are using AutoFilter, just erase all item's check boxes, and check only what you want.

Excel's filter doesn't delete rows - just hide it.

  • I'm seeking to match values in column 1 of a multicolumn dataset, with values from a separate list. If column 1 contains a match, copy that row (or alternatlively show that row and delete all the others). – user611028 Jun 29 '16 at 12:43

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.