I am trying to build a simple "to do" list using Excel. I would like to be able to "drag and drop" rows in the sequence that I desire. I envision each row having several columns of various information.
When I drag then drop the row into its new order I want it to be inserted into the new position and NOT replace an existing row. Quick example:
Row 1
Row 2
Row 3
Row 4
What I'm looking to do is move a row between existing row(s) but not replace any rows, so if I drag and drop row 2 to be below 3 it would be:
Row 1
Row 3
Row 2
Row 4
I have not been able to find anything to assist me when I search Excel's Help function.
Can anyone point me in the right direction on how to accomplish this?
This would be for Excel 2003 and also Excel 2010.
In advance, thanks.