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.

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.

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.

copy non-consecutive rows
 

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.

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.

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?

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?

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.