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.