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.

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 ...

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.

You can insert blanks rows above or below another in Excel, and you can even add them between each row that has data.