Enter a Formula Once and Copy Times

Consider this simple worksheet in Figure 6.3. Enter a simple formula like =C4*B4 in Cell D4, double-click the AutoFill handle, and the formula intelligently changes as at is copied down the range.

Figure 6.3

Double-click the AutoFill handle and Excel intelligently copies this relative-reference formula down the column.

D Microsoft Lxcet - Chapter6.xIs

Els Edr:

View Insert Formât

7 LO i Data yVfiüj.'j Help

0 0

Post a comment