Excel Use tips: Double-click a cell to move the selected cell
There is a quick way to move selected cells within a worksheet:
Position the mouse pointer over the side of the selected cell, and note that to select the side that is related to the move direction, move the mouse pointer to the bottom of the cell, and then position the mouse pointer to the right of the cell if you want to move to the right;
The mouse pointer changes to a white arrow, and the mouse pointer moves to a specific cell in the selected direction by double-clicking on the edge of the selected cell.
If the adjacent cell in this direction is a blank cell, it is moved to a blank cell that is farthest in succession;
If the adjacent cell in this direction is not a blank cell, it is moved to a nonblank cell that is farthest from the row.