View Single Post
 
Old 11-14-2011, 05:26 AM
fireman0174 fireman0174 is offline Mac OS X Microsoft Office 2008 for Mac
Novice
 
Join Date: Aug 2010
Posts: 8
fireman0174 is on a distinguished road
Default Drag and drop rows in Excel

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.

Last edited by fireman0174; 11-14-2011 at 06:53 AM.
Reply With Quote