Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to select non-adjacent cells with regular interval | Excel Discussion (Misc queries) | |||
In Excel how do I update cells in multiple sheets simultaneously? | Excel Discussion (Misc queries) | |||
Select a range of non-adjacent cells in Excel? | Excel Worksheet Functions | |||
tab does not move to adjacent cell in excel | Excel Discussion (Misc queries) | |||
excel tab key to move to right adjacent cell | Excel Discussion (Misc queries) |