How to Multiply a Column of Numbers Times a Percentage in Excel. Microsoft Office Excel includes dozens of function options to help you automatically generate values in cells across a spreadsheet.

Add the numbers to the column. First, you must add the preferred set of numbers to a column. You can decide however long you want it to be. From the image, our numbers range from A1 to A8.