Drag Rows to sort a list - shortcut? 1

[appelq]

I have a To-Do List in Excel, that I am constant reviewing and manually re-sorting items (rows).
As priorities change, I may want to move rows around.
What I do now:
Highlight the row,
hit [Ctrl]-[X],
Right-Click on the Row I want to move the cut row to, and select "Insert Cut Cells"
Which Moves the Row I right-Clicked on down.

It would be a LOT easier, if I could just Drag the row I'm interested in up to where I want to move it and by dropping it, have all the rows shift down. Of course what I get is "Do you want to Replace the contents of the destination cells". (no)

Is there a way to make Excel behave the way I described above?

Incidentally, it would also be nice, if the the procedure I use would not leave a Blank row where I "CUT" the original item from.
It would be nice if it could know to shift the cells up.

I hope that all makes sense.
It just occured to me that what I want it to do is exactly how moving items in the Internet Explorer "Favorites" list works. You can just drag the item up and it drops in in, shifting everything appropriately.

Thanks in advance,
Chuck

 

[mintjulep]

What are your criteria for for sorting?

Add a column or columns to enter some quantifiable critera, then use Excel's sorting to do the work for you.

 

[1726]

Hold the Shift key down while you drag and drop.

Readers may also want to explore other keys that modify mouse behaviour. e.g. Holding down Ctrl, or Shift + Ctrl while you drag the mouse.

 

[appelq]

Mintjulep - Thanks for the reply. Yes, I do that sometimes with a "Priority" column and using 1, 1.1, 1.2, 2.0, etc.

I think I just solved my own question though.

If I highlight a row, then hold the SHIFT key down while dragging the row up or down in the list, it inserts the row, shifting everything as needed.