Re: How do I cut & paste non-adjacent rows or columns ONLY in auto-fil
From: Bernie Deitrick (_at_)
Date: 01/11/05
- Next message: Bernard Liengme: "Re: Can I change the 15-digit limit in Excel for numbers ?"
- Previous message: Jose Mourinho: "Re: dating problems!"
- In reply to: Amadoda: "How do I cut & paste non-adjacent rows or columns ONLY in auto-fil"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 11 Jan 2005 08:01:16 -0500
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" <Amadoda@discussions.microsoft.com> wrote in message
news:090BD605-9A1E-4308-83B8-147212693BE4@microsoft.com...
> If I copy/paste from an auto-filtered *** 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 *** the
> intermediate cells are hidden until I [FORMAY/ROW/UNHIDE]. Also once you
> de-select back to ALL [UNDO] is not available!
- Next message: Bernard Liengme: "Re: Can I change the 15-digit limit in Excel for numbers ?"
- Previous message: Jose Mourinho: "Re: dating problems!"
- In reply to: Amadoda: "How do I cut & paste non-adjacent rows or columns ONLY in auto-fil"
- Messages sorted by: [ date ] [ thread ]
