How To Copy Cells From Excel Which Meet Search Criteria
Subscribe to the 
RSS Feed or by Email and receive free daily updates
You have a huge excel file and you want to copy all the cells in one column which match your search criteria and place it may be in another excel sheet.
Here is how you can do it:
Select the entire column on which you want to search:
Search using Control + F:
Select all the rows which are returned in the search results. this can be done by clicking on the first row in the “Find and Replace” window with results and then holding the “SHIFT” key and scrolling down the search results and clicking on the last row in the search results.
The cells get highlighted in the Excel sheet. Hit on the window bar on the Excel and hit “Control + C” (or just hit the “Copy” button)
The copies all the cells, now close the search window and go to another sheet and hit “Control +V” to paste the copied cells.
Popularity: 7% [?]
Subscribe to the RSS Feed or by Email and receive free daily updates
I have tried this a dozen times and cannot get it to work
Either I get an error message saying that “that function cannot be used on multiple selections” when I try to copy, or it just copies all cells in the entire column, not just the ones which match the search criteria/are listed in the search results
Oh geez, as soon as I posted this comment, I FINALLY got it.
The instruction “Hit on the window bar on the Excel and hit “Control + C”. ” is a bit unclear.
You JUST need to click “copy”, nothing else, no bar or column - even better to close the find and replace box FIRST, after all are selected and highlighted, BEFORE hitting copy
Thank you
@me
Glad you got it working, will modify that part to be more clear
What a great job!
This saves me all kinds of time!
uh!!! it gives me error when I try to copy (control + c), it says “that command cannot be used on multiple selections.”
do you know what the problem might be
Thank you
But how do you copy the whole row if you have multiple columns?
OMG I WAS JUST ABOUT TO FLIPPING OUT!!!! TANXS TANXS TANXS ME LOVE YOU LONG TIME