Copying Formulas Using Fill
Similar to filling a pattern of days or months, Excel can also fill cells with the pattern of a formula. For example, you might want to copy a formula if you have multiple rows or columns that require the same calculation.
Select the cell that has the formula you want to copy.
Position the mouse pointer on the lower-right corner of the beginning cell. The mouse pointer becomes a crosshair.
Press and hold the mouse button, ...
Get Easy Office 2013 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.
