How to Fill a Column with the Same Data in Excel. ... Right-click anywhere on the selected range of cells, and then click the first clipboard icon under "Paste Options." ...

An icon in the shape of an angle pointing down. We all know and love the Auto Fill feature in Excel. Microsoft went a step further in Excel 2013 and created Flash Fill.