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.

Sometimes, you want to add a new column to just part of a spreadsheet. That's easy to do as well. Step 1: Select the cells to the right of where you want to add the new column.

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.