| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy non-consecutive rows
i am copying non-conseutive rows from 1 workbook to paste into another
workbook. when i paste excel is pasting the enitire range of rows instead of only the selected rows. ex: i select rows 2,3,6,8-12,15 & 19 by holding control and clicking the row # then i press control+c to copy then i select cell A1 in a differnt workbook then i press control+v to paste excel pastes rows 2-10 can anyone explain what i am doing wrong? i am not pressing shift instead of control when i am selecting rows. it is clear after i copy that only the desired rows are selected. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copy non-consecutive rows
"confused" wrote: i am copying non-conseutive rows from 1 workbook to paste into another workbook. when i paste excel is pasting the enitire range of rows instead of only the selected rows. ex: i select rows 2,3,6,8-12,15 & 19 by holding control and clicking the row # then i press control+c to copy then i select cell A1 in a differnt workbook then i press control+v to paste excel pastes rows 2-19 can anyone explain what i am doing wrong? i am not pressing shift instead of control when i am selecting rows. it is clear after i copy that only the desired rows are selected. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copy non-consecutive rows
I just tried this (xl2002) using the row headers (1,4:6,10) and NOT
releasing the ctrl key touching copy while cursor still on row 10 markerselect ROW number in another workbookRIGHT clickpaste Seemed to work. -- Don Guillett SalesAid Software "confused" wrote in message ... i am copying non-conseutive rows from 1 workbook to paste into another workbook. when i paste excel is pasting the enitire range of rows instead of only the selected rows. ex: i select rows 2,3,6,8-12,15 & 19 by holding control and clicking the row # then i press control+c to copy then i select cell A1 in a differnt workbook then i press control+v to paste excel pastes rows 2-10 can anyone explain what i am doing wrong? i am not pressing shift instead of control when i am selecting rows. it is clear after i copy that only the desired rows are selected. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copy non-consecutive rows
Trick is to select the rows using the row indicatorthen RELEASE the ctrl
keythen use ctrl c or right click and use copythen goto destination and use ctrl+v or right click & paste -- Don Guillett SalesAid Software "Ross" wrote in message ... Hi Don~could you go back over that again. I just tried and couldn't get it to work. I keep getting "that command cannot be used on multiple selections". Thanks -- smither fan "Don Guillett" wrote: I just tried this (xl2002) using the row headers (1,4:6,10) and NOT releasing the ctrl key touching copy while cursor still on row 10 markerselect ROW number in another workbookRIGHT clickpaste Seemed to work. -- Don Guillett SalesAid Software "confused" wrote in message ... i am copying non-conseutive rows from 1 workbook to paste into another workbook. when i paste excel is pasting the enitire range of rows instead of only the selected rows. ex: i select rows 2,3,6,8-12,15 & 19 by holding control and clicking the row # then i press control+c to copy then i select cell A1 in a differnt workbook then i press control+v to paste excel pastes rows 2-10 can anyone explain what i am doing wrong? i am not pressing shift instead of control when i am selecting rows. it is clear after i copy that only the desired rows are selected. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copy non-consecutive rows
Ross
Excel is pasting rows 2,3,6,8:12,15,19 into A1:A10 consecutively in the target workbook. It won't paste those rows into 2,3,6,8:12,15,19 with blank rows included. Gord Dibben MS Excel MVP On Thu, 14 Sep 2006 17:10:02 -0700, Ross wrote: i am copying non-conseutive rows from 1 workbook to paste into another workbook. when i paste excel is pasting the enitire range of rows instead of only the selected rows. ex: i select rows 2,3,6,8-12,15 & 19 by holding control and clicking the row # then i press control+c to copy then i select cell A1 in a differnt workbook then i press control+v to paste excel pastes rows 2-10 can anyone explain what i am doing wrong? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copy non-consecutive rows
Took me awhile...I got it now...Thanks
-- smither fan "Gord Dibben" wrote: Ross Excel is pasting rows 2,3,6,8:12,15,19 into A1:A10 consecutively in the target workbook. It won't paste those rows into 2,3,6,8:12,15,19 with blank rows included. Gord Dibben MS Excel MVP On Thu, 14 Sep 2006 17:10:02 -0700, Ross wrote: i am copying non-conseutive rows from 1 workbook to paste into another workbook. when i paste excel is pasting the enitire range of rows instead of only the selected rows. ex: i select rows 2,3,6,8-12,15 & 19 by holding control and clicking the row # then i press control+c to copy then i select cell A1 in a differnt workbook then i press control+v to paste excel pastes rows 2-10 can anyone explain what i am doing wrong? |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copy non-consecutive rows
Thanks...got it now.
-- smither fan "Don Guillett" wrote: Trick is to select the rows using the row indicatorthen RELEASE the ctrl keythen use ctrl c or right click and use copythen goto destination and use ctrl+v or right click & paste -- Don Guillett SalesAid Software "Ross" wrote in message ... Hi Don~could you go back over that again. I just tried and couldn't get it to work. I keep getting "that command cannot be used on multiple selections". Thanks -- smither fan "Don Guillett" wrote: I just tried this (xl2002) using the row headers (1,4:6,10) and NOT releasing the ctrl key touching copy while cursor still on row 10 markerselect ROW number in another workbookRIGHT clickpaste Seemed to work. -- Don Guillett SalesAid Software "confused" wrote in message ... i am copying non-conseutive rows from 1 workbook to paste into another workbook. when i paste excel is pasting the enitire range of rows instead of only the selected rows. ex: i select rows 2,3,6,8-12,15 & 19 by holding control and clicking the row # then i press control+c to copy then i select cell A1 in a differnt workbook then i press control+v to paste excel pastes rows 2-10 can anyone explain what i am doing wrong? i am not pressing shift instead of control when i am selecting rows. it is clear after i copy that only the desired rows are selected. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I NOT copy hidden rows to a new worksheet? | Excel Discussion (Misc queries) | |||
| Hide Rows - copy and paste only rows that show | Excel Worksheet Functions | |||
| how do i copy rows using critera in a formula? | Excel Worksheet Functions | |||
| Excel find text and copy rows | Excel Discussion (Misc queries) | |||
| copy exact values from RangeA to Range B which has extra rows | Excel Discussion (Misc queries) | |||
Linear Mode
