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

A

Amadoda

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!
 
B

Bernie Deitrick

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

hidden rows, column copy-paste 0
Copying Rows with values in column A pasting in a new doccument and saving that doc 1
Auto Filter - It's broken! Help! (Office '03) 2
Problem with Pasting into Filtered Fields 2
Disabling copy/paste hidden cells 2
I copied Visible Cells Only, but it pastes only the first cell 1
Cut Non Adjacent Rows in Excel 2007 1
Cut & Paste visible cells on same row 5

Top