How to paste data over the hidden rows in a sheet with a filter

[Guest]

I have one sheet with a filter and one with non. How can I copy and paste
data from the sheet without a filter to the sheet with a filter without
pasting it in the hidden rows.

 

[Guest]

You can right click on the cell or row where you want to paste the data and
select "Insert copied cells" on the menu. This will give you options to
shift the data around.

Hope this helps,
Miguel.

 

[Dave Peterson]

Excel doesn't work like that.

Maybe you can sort the data on that filtered worksheet so that it's grouped the
same way you want to paste.

Then sort it back and reapply the filtering.