Copying Formulas
When you copy a formula, the formula is adjusted to fit the location of the cell to which it is copied. For example, if you copy the formula =C2+C3 from cell C4 to cell D4, the formula is adjusted for column D: it becomes =D2+D3. This allows you to copy similar formulas (such as the totals for a range of sales items) into a range of cells.
You can copy formulas using the Copy and Paste buttons (see Lesson 6), but there's a faster way.
Click the cell that contains the formula you want to copy.
Press Ctrl and drag the cell's border to the cell to which you want to copy your formula.
Release the mouse button, and Excel copies the formula to the new location.
If you want to copy a formula to a neighboring range of cells, follow these ...
Get Ten Minute Guide to Excel 97 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
