Moving cells

[robin]

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 Mochikun]

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]

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

 

[Gord Dibben]

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

 

[robin]

Thanks, Gord, that works for me, too.

robin

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

 

[Joerg Mochikun]

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