Moving cells

R

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

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
 
R

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
 
G

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
 
R

robin

Thanks, Gord, that works for me, too.

robin
Gord Dibben said:
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
 
J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top