Steps:

1.Select cells from which to copy data to other cells.
2.Place the mouse cursor on the lower right-hand corner of the cells you selected. The shape of the mouse cursor will change to “+”.
3.Hold down the left mouse button and drag “+” across the cells in the direction you want to fill.
4.The data in the range of the cells you dragged across will change to the data of the copied cells.