Moving a row from one sheet to another wrongly leaves blank-row artifact.

[baobob]

Moving an entire row within a sheet in Excel XP is implemented
correctly:

Select the entire row, cut it, go to the target location, and Insert
Copied Cells. The target row is inserted (pushing all rows below it
down), and the source row is deleted (bringing all rows below it up, as
it were).

NOT so when the target is in another sheet in the same workbook.

Excel inserts the target row correctly, but fails to delete the source
row. The row still exists (only it's blanked out). You have to remeber
to, tediously, return to the source and delete the blank row. Which
means that if you intended to continue working in the target sheet, you
end up having to navigate there TWICE.

Microsoft requires you to do the work Excel should do, because Excel
DOES do it, in the former context.

Copy means COPY, and move means MOVE. And move DOESN'T mean
keep-but-merely-blank-out the source.

A Microsoft design rationale for implementing different behavior in
these contexts aside--and I'm sure there is one--is there an option to
make Excel delete the source row after all row moves?

Thanks.

***

 

[baobob]

Belated thanks to both who replied.

And that's a great workaround, to spend a couple extra keystrokes and
delete before leaving your source location, then insert & paste at the
target from the Clipboard.

That maintains your mental order of cut-->paste intact.

I shoulda thought of that. Duh.

***

 

[Ragdyer]

It always bothers me though ... to delete.

If something goes wrong, you can't easily recuperate.

You'll have to close *without* saving, and then, of course, you *also* lose
all your work since your last save.

It would pay to Save *before* you start this type of procedure.

Anyway, appreciate your feed-back.