Move multiple rows of data that are not sequential

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I move multiple rows of data that are not sequential - I want to move
row 1, 15, and 23 for example - how can I select and move multiple things at
one time?

In another way, I have data on multiple rows with multiple columns and I
need all of the data on one row - how can I do that without cutting and
pasting each individual row?
 
Hi Mel,
I presume you tried to copy discontiguous rows and were told by Excel that you can't.

You can't do what you are asking for now either.

You can move your rows one at a time (sorting might be easier, if that is an option).
You can move a row by selecting the row, grab the boundary with Shift and drag
to where you want it.
http://www.mvps.org/dmcritchie/excel/fillhand.htm#mouse
 
You must log in or register to reply here.

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

How to move data from rows to columns 6
Merging multiple columns into one column (dynamically) 1
Pivot Table - Easy way to add multiple Columns into Data section? 6
Function to move data 1
VBA Delete row based on multiple columns of data 3
Conditionally format last row of matching criteria 5
Sorting multiple rows... 4
Excel Sequential Numbering System 0

Back
Top