How do I cut & paste non-adjacent rows or columns ONLY in auto-fil
 

If I copy/paste from an auto-filtered sheet I copy/paste only the highlighted
rows. If I CUT/paste, I cut and paste all the intermediate cells hidden by
the auto-filter. I don't want that! (Note: in the paste sheet the
intermediate cells are hidden until I [FORMAY/ROW/UNHIDE]. Also once you
de-select back to ALL [UNDO] is not available!

Amododa,

You cannot cut/paste multiple area selections. So, you need to copy/paste,
and then go back to your filtered list and use Edit / Go To... / Special /
Visible Cells only, then delete.

HTH,
Bernie
MS Excel MVP

"Amadoda" wrote in message
...
If I copy/paste from an auto-filtered sheet I copy/paste only the
highlighted
rows. If I CUT/paste, I cut and paste all the intermediate cells hidden
by
the auto-filter. I don't want that! (Note: in the paste sheet the
intermediate cells are hidden until I [FORMAY/ROW/UNHIDE]. Also once you
de-select back to ALL [UNDO] is not available!