copy and paste non-adjacent rows

G

Guest

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

Guest

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy and Paste Macro 1
Cut Non Adjacent Rows in Excel 2007 1
How to select data in non adjacent rows of a column automatically 5
pasting content copied from nonadajacent cells 1
Enter value zero into all cells in multiple ranges? 4
deselect row/column from multiple selection 2
Date Stamp 7
excel 2007 select multiple cells 1

Top