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