When I create a filter in Google Sheets and then do a block selection on the results, copying this copies the rows between them as well. How can I only copy the content that I can actually see using my filter?


Sentence        Type
Hello           greeting
Bye             farewell
Hi              greeting

Filtering this by only selecting the Type of "greeting" gives this:

Hello           greeting
Hi              greeting

But if I select those two lines and copy paste them somewhere else, the "Bye" line is copied as well.

P.S.: As requested, I created a MWE under https://docs.google.com/spreadsheets/d/1d1bH1r7-FZWO52Wqvk5UytHcQFUSg_DjqJgk6qs98Z4/edit?usp=sharing. Strangely though, it works perfectly fine there...

  • I can't reproduce this. When I filter the data and copy-paste, only the visible cells get copied. Can you share a sample spreadsheet where you have this problem? – user79865 Aug 25 '15 at 16:52
  • @Normal Human: Can I do this without exposing my Google Account name? I don't want to create a link between my stackexchange account and my Google Email. – Konrad Höffner Aug 26 '15 at 8:07
  • You could create another Google account just for that purpose. – user79865 Aug 26 '15 at 11:30
  • Still no reproducible example, then... Wild guess: does your spreadsheet happen to be using the old version of Google Sheets? – user79865 Aug 28 '15 at 22:49
  • @NormalHuman That is well possible, as I generally use the old version of Google Drive as well. I will try to reproduce this. – Konrad Höffner Aug 29 '15 at 7:14

Your Answer

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

Browse other questions tagged or ask your own question.