Copying Formulas

[ LiB ]

Now that you've created a formula, there's no reason to type it repeatedly for subsequent cells . Let Excel copy the formula for you! When you copy a formula, the formula changes depending on where you put it. It is said, therefore, to be relative relative to the position of the original formula.

Copying Using the Fill Feature

If you're going to copy a formula to a surrounding cell , you can use the Fill method. You first learned about the Fill command in Chapter 3, "Editing a Worksheet."

Copying with Copy and Paste

If the originating cells and the recipient cells are not sequential, you can use copy and paste. You first learned about copy and paste in Chapter 3, "Editing a Worksheet."

[ LiB ]