View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Select and move two NON-ADJACENT Excel cells simultaneously ?

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

"Otto Moehrbach" wrote in message
...
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
"Vulture" wrote in message
...
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.