Can You Switch Rows
 

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.

Can You Switch Rows
 

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.

Can You Switch Rows
 

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)