If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
pasting content copied from nonadajacent cells
I am trying to copy text from nonadjacent cells in a row in one spreadsheet
using Control/Select/Copy, and paste the text into adjacent cells in a row in another spreadsheet. When I paste the content in, all the content from cells between those I copied will paste in also. For instance if I copy C5, F5 and H5, then paste into new spreadsheet, I'll get C5, D5, E5, F5, G5 and H5. Excel help does not say anything about pasting content, only how to copy it. -- d.adams |
#2
|
|||
|
|||
pasting content copied from nonadajacent cells
This can only be done when copied cells are in same column or row.
Hold CTRL key and click on each of the non-contiguous cells C5, F5 and H5 Copy then paste. Gord Dibben MS Excel MVP On Fri, 20 Nov 2009 12:00:02 -0800, d.adams wrote: I am trying to copy text from nonadjacent cells in a row in one spreadsheet using Control/Select/Copy, and paste the text into adjacent cells in a row in another spreadsheet. When I paste the content in, all the content from cells between those I copied will paste in also. For instance if I copy C5, F5 and H5, then paste into new spreadsheet, I'll get C5, D5, E5, F5, G5 and H5. Excel help does not say anything about pasting content, only how to copy it. |
Thread Tools | |
Display Modes | |
|
|