Excel drag and drop
Posted on 2011-05-02
Is there a way in Excel to allow someone to drag-and-drop a cell to move it around, instead of pointing at the border to do it? I want the user to be able to click anywhere on a cell to drag and drop it...instead of clicking on the cell, then pointing at the border, then drag and drop. So rather than highlighting an area, it would drag and drop the cell.
Part 2 of this question...when the user clicks on the cell to drag and drop it, is there a way to take the 3 cells to the left with it. For example, if the user clicks on cell E5 to move it, I want cells B5, C5, & D5 to move with it (via the drag and drop).