ExcelBanter - copy and paste non-adjacent rows

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - copy and paste non-adjacent rows (https://www.excelbanter.com/excel-discussion-misc-queries/98846-copy-paste-non-adjacent-rows.html)

Nesa

copy and paste non-adjacent rows

How do I copy and paste non-adjacent rows in an Excel spreadsheet to a new
spreadsheet?

Terry Tipsy

copy and paste non-adjacent rows

Select your first row then hold down your 'CTRL' key and select the other
rows to be copied. Then edit/copy/paste as normal.
--
T Tipsy

"Nesa" wrote:

How do I copy and paste non-adjacent rows in an Excel spreadsheet to a new
spreadsheet?

slscanlon3

copy and paste non-adjacent rows

But how do you PASTE them nonadjacent. If you do it like that it will
copy them if they are nonadjacent, but it will paste them all together.

Terry Tipsy wrote:
Select your first row then hold down your 'CTRL' key and select the other
rows to be copied. Then edit/copy/paste as normal.
--
T Tipsy

"Nesa" wrote:

How do I copy and paste non-adjacent rows in an Excel spreadsheet to a new
spreadsheet?

All times are GMT +1. The time now is 05:53 AM.