Hi,

In Microsoft Works, to change the order of a rows of cells, I can cut a row
of cells, paste it into another row, and it "bumps" all the rows beneath it
down. In Excel 2003, I have to first insert a blank row, then cut and paste
the row of cells into that blank row.

Similarly, in Works, if I want to eliminate a blank row, I can cut it, then
all the rows beneath it will move up to fill the space. In Excel, I have to
cut all of the rows beneath the vacant cells, and then paste them in their
proper position. Is there a way to change the default settings in Excel to
behave the way they do in Works?

Thank you.

No problem in Excel:

Method a) Cut source row, select target row (the row that should be shifted
down), right-click your mouse and select "Insert cut cells".

Method b) Select the source and drag with the mouse to the new location
while pressing SHIFT key.

Joerg

"robin" wrote in message
...
Hi,

In Microsoft Works, to change the order of a rows of cells, I can cut a
row of cells, paste it into another row, and it "bumps" all the rows
beneath it down. In Excel 2003, I have to first insert a blank row, then
cut and paste the row of cells into that blank row.

Similarly, in Works, if I want to eliminate a blank row, I can cut it,
then all the rows beneath it will move up to fill the space. In Excel, I
have to cut all of the rows beneath the vacant cells, and then paste them
in their proper position. Is there a way to change the default settings in
Excel to behave the way they do in Works?

Thank you.

Joerg, method (a) worked great. Thanks! I couldn't get method (b) to work,
though. After I select the source row, if I try to drag it I end up
selecting more rows instead. It's as if pressing SHIFT doesn't do anything.

robin

"Joerg Mochikun" wrote in message
...
No problem in Excel:

Method a) Cut source row, select target row (the row that should be
shifted down), right-click your mouse and select "Insert cut cells".

Method b) Select the source and drag with the mouse to the new location
while pressing SHIFT key.

Joerg

"robin" wrote in message
...
Hi,

In Microsoft Works, to change the order of a rows of cells, I can cut a
row of cells, paste it into another row, and it "bumps" all the rows
beneath it down. In Excel 2003, I have to first insert a blank row, then
cut and paste the row of cells into that blank row.

Similarly, in Works, if I want to eliminate a blank row, I can cut it,
then all the rows beneath it will move up to fill the space. In Excel, I
have to cut all of the rows beneath the vacant cells, and then paste them
in their proper position. Is there a way to change the default settings
in Excel to behave the way they do in Works?

Thank you.

Don't cut the row, just delete it and all below will move up.

Select the row header and CTRL + hyphen.


Gord Dibben MS Excel MVP

On Fri, 20 Feb 2009 11:06:52 -0700, "robin" wrote:

Joerg, method (a) worked great. Thanks! I couldn't get method (b) to work,
though. After I select the source row, if I try to drag it I end up
selecting more rows instead. It's as if pressing SHIFT doesn't do anything.

robin

"Joerg Mochikun" wrote in message
...
No problem in Excel:

Method a) Cut source row, select target row (the row that should be
shifted down), right-click your mouse and select "Insert cut cells".

Method b) Select the source and drag with the mouse to the new location
while pressing SHIFT key.

Joerg

"robin" wrote in message
...
Hi,

In Microsoft Works, to change the order of a rows of cells, I can cut a
row of cells, paste it into another row, and it "bumps" all the rows
beneath it down. In Excel 2003, I have to first insert a blank row, then
cut and paste the row of cells into that blank row.

Similarly, in Works, if I want to eliminate a blank row, I can cut it,
then all the rows beneath it will move up to fill the space. In Excel, I
have to cut all of the rows beneath the vacant cells, and then paste them
in their proper position. Is there a way to change the default settings
in Excel to behave the way they do in Works?

Thank you.

Thanks, Gord, that works for me, too.

robin
"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Don't cut the row, just delete it and all below will move up.

Select the row header and CTRL + hyphen.


Gord Dibben MS Excel MVP

On Fri, 20 Feb 2009 11:06:52 -0700, "robin" wrote:

Joerg, method (a) worked great. Thanks! I couldn't get method (b) to work,
though. After I select the source row, if I try to drag it I end up
selecting more rows instead. It's as if pressing SHIFT doesn't do
anything.

robin

"Joerg Mochikun" wrote in message
...
No problem in Excel:

Method a) Cut source row, select target row (the row that should be
shifted down), right-click your mouse and select "Insert cut cells".

Method b) Select the source and drag with the mouse to the new location
while pressing SHIFT key.

Joerg

"robin" wrote in message
...
Hi,

In Microsoft Works, to change the order of a rows of cells, I can cut a
row of cells, paste it into another row, and it "bumps" all the rows
beneath it down. In Excel 2003, I have to first insert a blank row,
then
cut and paste the row of cells into that blank row.

Similarly, in Works, if I want to eliminate a blank row, I can cut it,
then all the rows beneath it will move up to fill the space. In Excel,
I
have to cut all of the rows beneath the vacant cells, and then paste
them
in their proper position. Is there a way to change the default settings
in Excel to behave the way they do in Works?

Thank you.

Robin, for method b): After selecting the row, you must move the mouse
cursor a bit to the right. You stayed at the row header at the left .
Noticed the splitbar mouse cursor (small bar with up and down arrows
attached)? If you press SHIFT you select more rows. Sure that's not what you
wanted to do. However if you move your mouse cursor to the right, the mouse
cursor will change into one with little arrows in all 4 directions (I think
it's called the 'Move' cursor). If you now press SHIFT and move the row with
the mouse, you can switch rows.

Joerg

"robin" wrote in message
...
Joerg, method (a) worked great. Thanks! I couldn't get method (b) to work,
though. After I select the source row, if I try to drag it I end up
selecting more rows instead. It's as if pressing SHIFT doesn't do
anything.

robin

"Joerg Mochikun" wrote in message
...
No problem in Excel:

Method a) Cut source row, select target row (the row that should be
shifted down), right-click your mouse and select "Insert cut cells".

Method b) Select the source and drag with the mouse to the new location
while pressing SHIFT key.

Joerg

"robin" wrote in message
...
Hi,

In Microsoft Works, to change the order of a rows of cells, I can cut a
row of cells, paste it into another row, and it "bumps" all the rows
beneath it down. In Excel 2003, I have to first insert a blank row, then
cut and paste the row of cells into that blank row.

Similarly, in Works, if I want to eliminate a blank row, I can cut it,
then all the rows beneath it will move up to fill the space. In Excel, I
have to cut all of the rows beneath the vacant cells, and then paste
them in their proper position. Is there a way to change the default
settings in Excel to behave the way they do in Works?

Thank you.