Open your spreadsheet in Microsoft Excel 2007. Click the first data point in the column to select it. Hold the "Shift" key and click the last data point in the list.

How to Fill a Column with the Same Data in Excel. ... Select the range of cells in which you want to enter the same data. Type the data. ... How to Change Columns Into Rows in Excel 2007.