Click on the first cell in the range whose data you want to duplicate.
Enter the data into the cell.
Then move the pointer of your mouse to the bottom, right-hand corner of the cell. The pointer of your mouse would turn to a + sign. When it does…Hold down the left button on your computer mouse and drag across to fill a horizontal range or down to fill a vertical range.
Excel will fill the range with the same data.