Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
One way:
a. select the row to be moved and use Edit Cut b. select the row below where you want the cut row to go and use Edit Insert cut cells Thanks that works great if the rows are adjacent to each other, and I can use that. But Is there a way to do it when the rows are say, 10 rows apart? The same two steps work with any pair or rows, even if they're separated by others. Scroll if they're not on screen at the same time. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
On Fri, 02 Dec 2005 14:30:29 -0800, Jay
wrote: One way: a. select the row to be moved and use Edit Cut b. select the row below where you want the cut row to go and use Edit Insert cut cells Thanks that works great if the rows are adjacent to each other, and I can use that. But Is there a way to do it when the rows are say, 10 rows apart? The same two steps work with any pair or rows, even if they're separated by others. Scroll if they're not on screen at the same time. Thanks for the help, but this is what happens if I do as you say. 1 2 3 4 5 6 7 8 9 10 If I want to switch row 4 and row 9, and I follow your instructions. [Select row 4editcut. Select row 10insertcut cells. Then it ends up looking like this: 1 2 3 5 6 7 8 9 4 10 When what I want is this: 1 2 3 9 5 6 7 8 4 10 Thanks. |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Just do it a second time, moving row "9" into the position you want.
On Sat, 03 Dec 2005 00:13:56 -0800, Larry C wrote: On Fri, 02 Dec 2005 14:30:29 -0800, Jay wrote: One way: a. select the row to be moved and use Edit Cut b. select the row below where you want the cut row to go and use Edit Insert cut cells Thanks that works great if the rows are adjacent to each other, and I can use that. But Is there a way to do it when the rows are say, 10 rows apart? The same two steps work with any pair or rows, even if they're separated by others. Scroll if they're not on screen at the same time. Thanks for the help, but this is what happens if I do as you say. 1 2 3 4 5 6 7 8 9 10 If I want to switch row 4 and row 9, and I follow your instructions. [Select row 4editcut. Select row 10insertcut cells. Then it ends up looking like this: 1 2 3 5 6 7 8 9 4 10 When what I want is this: 1 2 3 9 5 6 7 8 4 10 Thanks. -- Jay. (remove dashes for legal email address) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can You Switch Rows | Excel Discussion (Misc queries) | |||
How can I switch so that rows are referenced with letters, and co. | Excel Discussion (Misc queries) | |||
Switch Rows and Columns | Excel Discussion (Misc queries) | |||
Adding Rows to Master Sheet | New Users to Excel | |||
switch colums and rows | New Users to Excel |