Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Mel" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Putting data from multiple worksheets into one | Excel Discussion (Misc queries) | |||
Select rows of data in a worksheet on one criteria in multiple co | Excel Worksheet Functions | |||
Macro that will add data from multiple workbooks to the 1st open r | Excel Discussion (Misc queries) | |||
Finding common data in multiple columns and rows in Excel | Excel Worksheet Functions | |||
Lookup values in a list and return multiple rows of data | Excel Worksheet Functions |