1. Select the Cell Which you want to copy and paste in the cells that were below the cell.
2. Press Shift Button and select the last cell up to which you want to fill down.
3. Right Click and Select the Fill Down Option or else press Ctrl+E to Fill down a set of common item in the columns.
watch this video below for better understanding.
If you liked this tutorial, share it with your friends. And also you can follow us on Youtube, Twitter and Facebook. We would love to hear from you, Please do comment, suggest or compliment our work and we shall make it better for you.
You can write us at firstname.lastname@example.org