Copying formulas in Excel is a relatively simple operation - unless you need to copy down through dozens or even hundreds of cells. Here's a foolproof little trick that will knock out the task for ...

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.

Use Excel's Paste Special feature to calculate multiple values against a data range, at the same time. You can make the process even more efficient with keyboard shortcut combinations.