Using fill handle
Do you notice a tiny box at the bottom right corner of the selection? This is fill handle. This little feature has so much to offer. Basically it helps fill the data mostly a series automatically. Due to the same reason it is also called autofill handle. To learn more about autofill and its use read this article:
But we can use it to copy and paste the data easily.
8. Copy/paste or Fill single cell repeatedly
Make that cell active and simply drag the fill handle down the column or across the column to fill or paste the same data in other cells.
9. Copy/paste or Fill multiple cells repeatedly
Select the cells you want to copy and paste. Press and hold Ctrl key on the keyboard and now drag the fill handle. Excel will fill the cells with the same data one cell at a time.
10. Bonus: Shift key + Fill handle
Instead of holding down Ctrl key if you press and hold Shift key, Excel will not only copy/paste the data but also add additional rows or columns in place. So it acts more like copy/insert instead of copy/paste.
11. Bonus: Double click fill handle to fill quickly
Instead of dragging the fill handle you can even double click the fill handle and Excel will fill the range of cells instantly for you. However, to do this Excel needs certain data to be present around the active cell otherwise it won’t work.