Google-sheets – Copying filtered data in Google Sheets

google sheetsgoogle-sheets-filter

What is the correct method for copying data in a filtered view in Google Sheets?

For example, in the image below, I want to copy the cells with values 1 & 3 and paste them into the cells with value a & c.

enter image description here

If I filter the view to only show those values, I want to make sure that the cells with value 2 & b are not impacted.

enter image description here

I am raising this question since I made assumptions that ended up corrupting a lot of data on a Google sheet.

Best Answer

I ran the test (video here) which shows what happens for each of the operations. I tested: Cut & Paste, Copy & Paste & Delete, and Dragging cells. enter image description here You can see from the resulting image that the only operation that gave the expected results while in filtered view was to copy the cells, paste them, and then delete the data from the original cells. You can imagine how badly data can get corrupted if you are filtering rows over a large range and assuming your not impacting the filtered data.

Related Topic