For example, lets say I have value 10 and 20 in E1 and E3 cell. And when I select E1 to E4 and drag the selection downward I get 30, 40, 50 in the similar manner. I want to do this without drag and drop because my downward selection range would be large.

I want to copy the selection E1 to E4 and then select E5 to say E1000(ctrl+shift+down to E1000) to paste like drag and drop.

Thank you.