Skip to main content
Super User

Return to Answer

deleted 178 characters in body
Source Link
robotik
robotik
  • 160
  • 5

Okay, here is what I found. When using autofilters, only the filtered results get selected EXCEPTCOPIED, but if you added some columns after addingCUT the autofilter. So if you find that copy/paste of filtered results doesn't work as expectedselection, turn off autofilterboth visible and then back again. After that, it will workunvisible cells are moved.

Okay, here is what I found. When using autofilters, only the filtered results get selected EXCEPT if you added some columns after adding the autofilter. So if you find that copy/paste of filtered results doesn't work as expected, turn off autofilter and then back again. After that, it will work.

Okay, here is what I found. When using autofilters, only the filtered results get COPIED, but if you CUT the selection, both visible and unvisible cells are moved.

Source Link
robotik
robotik
  • 160
  • 5

Okay, here is what I found. When using autofilters, only the filtered results get selected EXCEPT if you added some columns after adding the autofilter. So if you find that copy/paste of filtered results doesn't work as expected, turn off autofilter and then back again. After that, it will work.