Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Select and move two NON-ADJACENT Excel cells simultaneously ?

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.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,651
Default Select and move two NON-ADJACENT Excel cells simultaneously ?

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.
--
David Biddulph

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



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,071
Default Select and move two NON-ADJACENT Excel cells simultaneously ?

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.



  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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.





  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,071
Default Select and move two NON-ADJACENT Excel cells simultaneously ?

Thanks David, I didn't know that. Otto
"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
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.







Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need to select non-adjacent cells with regular interval rickhoff Excel Discussion (Misc queries) 3 June 10th 13 10:18 AM
In Excel how do I update cells in multiple sheets simultaneously? kjh1210 Excel Discussion (Misc queries) 1 April 22nd 09 11:01 PM
Select a range of non-adjacent cells in Excel? hodgsonk Excel Worksheet Functions 12 July 1st 06 04:34 AM
tab does not move to adjacent cell in excel Karen Boyd Excel Discussion (Misc queries) 1 September 21st 05 07:09 PM
excel tab key to move to right adjacent cell dwillie Excel Discussion (Misc queries) 2 January 26th 05 08:01 PM


All times are GMT +1. The time now is 11:29 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"