Can You Switch Rows

L

Larry C

Hi,

I have two rows in a spreadsheet I just want to "switch."

Is there a simple way to do this without first having to add a blank
row, move one row up and then delete the blank row again?

Thanks
 
J

Jay

I have two rows in a spreadsheet I just want to "switch."
Is there a simple way to do this without first having to add a blank
row, move one row up and then delete the blank row again?
Click to expand...

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
 
K

Ken Wright

Hover over the edge between Col A and the row numbers, and when it turns to
a black 4 headed arrow, right click, hold it and drag the row to where you
want it, and when you let go it will prompt you with a number of options,
including move here and shift down etc.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission :)
------------------------------­------------------------------­----------------
 
N

Niek Otten

click 1st column header
CTRL-X
click-next-to-the-other column header
click the "insert column" icon (Can be copied from the Insert command set)
 
L

Larry C

Hover over the edge between Col A and the row numbers, and when it turns to
a black 4 headed arrow, right click, hold it and drag the row to where you
want it, and when you let go it will prompt you with a number of options,
including move here and shift down etc.
Click to expand...


I get to the "black 4 headed arrow" part, but once I do that there is
no way to right click and then drag. I can left click and then drag,
but that doesn't accomplish anything. What am I missing?

Thanks
 
L

Larry C

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
Click to expand...

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?

Thanks
 
K

Ken Wright

What version Excel? Has been that way for some time as far as I can recall.
Am on a laptop at the moment so only have the last couple of versions to
hand.

Assuming the whole row is selected, and you then hover and see the 4 headed
arrow, when you right click, hold odwn the button and then drag, all you see
being dragged is an outline, and then when you let go you suddenly see a
whole host of additional commands such as Copy here, Move Here, Move here
and Shift Down etc etc

Regards
Ken.............
 
J

Jay

One way:
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?
Click to expand...

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.
 
L

Larry C

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.
Click to expand...

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 4>edit>cut. Select row 10>insert>cut 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.
 
L

Larry C

What version Excel? Has been that way for some time as far as I can recall.
Am on a laptop at the moment so only have the last couple of versions to
hand.

Assuming the whole row is selected, and you then hover and see the 4 headed
arrow, when you right click, hold odwn the button and then drag, all you see
being dragged is an outline, and then when you let go you suddenly see a
whole host of additional commands such as Copy here, Move Here, Move here
and Shift Down etc etc

Regards
Ken.............
Click to expand...

It won't let me right click and drag. I'm using Excel 2000.
 
K

Ken Wright

Just tried it in XL2000 and it works fine. One slight difference though is
that you don't get the 4 headed arrow, you get a white arrow. With the row
selected, hover between the top and bottom of the row, and between Col A and
the row number, so that you are right in the middle. When it turns to a
white arrow, right click, hold it down and drag up or down. Then just let
go and you will see the options.

Regards
Ken.............
 
J

Jay Somerset

Just do it a second time, moving row "9" into the position you want.

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.
Click to expand...

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 4>edit>cut. Select row 10>insert>cut 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.
Click to expand...
 
Top