How to fill a Range with the same Data

Click on the first cell in the range whose data you want to duplicate.

Enter the data into the cell.

How-to-fill-a-range-with-the-same-data - 1

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.

Lesson 15: How to autofill a series of numbers, dates and alpha-numeric values