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: 5% [?]





















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