Please read my answer before answering. I NEVER talked about dragging, only selecting your range before Paste Special Add

Select the first cell - While holding down the Ctrl and the Shift key hit the down arrow. Voilà -

As for your second request, I do not understand what you want.
EDIT : on second thought i added you to my "ignore list"

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post