When content is being copied from one range of cells to another, all source cells need to be selected before the Copy button is clicked, and all destination cells need to be selected before the Paste button is clicked.

Question

Quizplus · Accepted Answer

Only the source cells need to be selected before copying. For pasting, you only need to select the top-left cell of the destination range; you don't need to select all destination cells.

When Content Is Being Copied from One Range of Cells