Select and move two NON-ADJACENT Excel cells simultaneously ?

[Vulture]

How do I select two or more Excel cells which are NON-ADJACENT (i.e. NOT
touching each other) so that I can move, copy, or otherwise manipulate them
AT THE SAME TIME ?

I tried the Excel Help, doing all sorts of searches, and I have to say that
it, like many other Help packages, is just not user-friendly _ at least, not
good at answering the simpler questions in plain English. But hopefully
posting the query here will get better results.

 

[David Biddulph]

To select non-adjacent cells, use the standard Windows technique of Control
click.
But some things (such as copy) you can't do with non-adjacent cells. You
can do formatting and various other actions, but not copying. The problem
isn't with how to select them, but with what you are allowed to do with them
when they're selected.

 

[Otto Moehrbach]

You can select non-contiguous cells like David said, but you can copy them
also. However, when you paste them somewhere, they will be pasted in
contiguous cells. In other words, say that you select A1 and E1 and do
Copy. Then you paste into A2. The 2 cells will be pasted into A2:B2. HTH
Otto

 

[David Biddulph]

You can copy with, for example, A1 and E1, but not A1 and E5. [The error
message is "That command cannot be used on multiple selections."]
http://support.microsoft.com/kb/214080

 

[Otto Moehrbach]

Thanks David, I didn't know that. Otto

You can copy with, for example, A1 and E1, but not A1 and E5. [The error
message is "That command cannot be used on multiple selections."]
http://support.microsoft.com/kb/214080
--
David Biddulph

You can select non-contiguous cells like David said, but you can copy
them also. However, when you paste them somewhere, they will be pasted
in contiguous cells. In other words, say that you select A1 and E1 and
do Copy. Then you paste into A2. The 2 cells will be pasted into A2:B2.
HTH Otto