Select and move two NON-ADJACENT Excel cells simultaneously ?

V

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.
 
D

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.
 
O

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
 
O

Otto Moehrbach

Thanks David, I didn't know that. Otto
David Biddulph said:
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 said:
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
 

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

Top