Strange paste selection behavior

[1scant]

I have been copying a single cell to contiguous cells in a column and
have always found that after the paste operation, the final active cell
will be the top-most, or first, cell of the paste range. For example,
if the paste range extends for several screens and, after the paste, I
hit the cursor down button, I will go back to the first screen and the
active cell will be the second cell of the range.

However, I was earlier working in another workbook doing the exact same
thing. But the final active cell after the paste would be the last cell
of the range.

I prefer the second behavior, but can find no reason for it to be
happening. Does anyone know where the option is that sets this kind of
behavior?

 

[Kevin B]

If you want the last cell in the range to be selected, start your selection
in the last cell and drag toward the first cell. The active cell in a
selection is always the first cell selected.