How to Copy Formulas Down in Excel Lightning Fast
Microsoft Excel 2010 formulas allow you to perform mathematical functions on any number of values held within individual cells on the spreadsheet. Some formulas can be so long that just typing them in takes several minutes, and if you need to enter the same formula into multiple cells, it can take forever. While you can always copy a formula and paste it into additional cells, Excel includes a faster way to copy formulas into adjacent cells.
Other People Are Reading
Instructions
-
-
1
Open the Excel 2010 spreadsheet where you want to add your formula.
-
2
Select the first cell where you want the formula to appear and type in your formula. Press "Enter" when you are done.
-
-
3
Move the mouse to the cell where you just entered your formula. Move the pointer over the bottom-right corner of that cell and it will change into a "+" sign.
-
4
Click and hold the mouse button. Drag the mouse down the spreadsheet until you reach the last cell where you want the formula to appear. Release the mouse button, and the formula will instantly copy itself down into every cell.
-
1
Tips & Warnings
Copied formulas use relative references, so a reference of cell "A1" in your formula will change in both the column and row relative to the difference between the original formula cell and the copied formula cell. To avoid this, place a "$" in front of either the column letter, row number, or both.
