G Guest Jul 12, 2006 #1 How do I copy and paste non-adjacent rows in an Excel spreadsheet to a new spreadsheet?
G Guest Jul 12, 2006 #2 Select your first row then hold down your 'CTRL' key and select the other rows to be copied. Then edit/copy/paste as normal.
Select your first row then hold down your 'CTRL' key and select the other rows to be copied. Then edit/copy/paste as normal.
S slscanlon3 Jul 12, 2006 #3 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.
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.