While dragging a range of cells, if the new location is not visible, drag the selected range to the edge of the worksheet in the direction you want to scroll.

Question

Quizplus · Accepted Answer

When you drag a range of cells to the edge of the worksheet, Excel will automatically scroll in that direction, allowing you to drop the cells into a new location that was not initially visible.

While Dragging a Range of Cells, If the New Location