Hold down Shift while you drag the row. That way it will be inserted where
you drop it.

/Marcus


"Trish" wrote:

Excel 2003 - I have several rows of data. I need to move the bottom row
further up. If I simply cut and paste, or drag and drop, the moved text
will overwrite what was already there. With technology constantly being
improved, has Microsoft come up with a way of avoiding that, ie if the row
was moved in a certain way, eg by holding down an additional key, or
whatever, can the rows above and below the destination make way for the new
row to be inserted? Otherwise I always have to insert a blank row before
moving the row up.

A big ask probably, but worth a try!

Thanks.