Multiplying an entire Excel column by the results of a formula can be a little tricky, especially if the formula is complicated or subject to change.

1] Copy the same formula to other cells in Excel using keyboard shortcuts It is possible to use keyboard shortcuts to easily add formulas to other parts of a workbook.

How to Add Cells Across Multiple Spreadsheets. Adding data that spans multiple Excel spreadsheets might appear daunting at first, but Microsoft simplifies the task with two referencing methods.