How do I copy a formula in Excel?
Often times you will want to enter the same formula through a range of cells, for example, at the end of series of columns or rows. Here's a tip that can save you some time. Start by selecting all the cells where you want the formulas to go. Now, instead of entering the first formula and copying it to the other cells, type your first formula and (before you press Enter) hold down the Ctrl key, then press Enter. The formula will be entered in all of the selected cells, almost like magic.