O'Reilly logo

Picture Yourself Learning Microsoft® Excel® 2010 by Laurie Ulrich Fuller, Deidre Hayes, Jeffery A. Riley

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Copying Formulas

ANOTHER THING THAT’S COOL about Excel’s formulas is how easy it is to reuse them. For example, after you carefully type in a formula that calculates the number of black bean taquitos available for sale during August, taking into account any deliveries or returns during the month, you don’t want to repeat the process with the next item in your inventory. Luckily, Excel allows you to copy formulas, automatically adjusting the cell references for you. For example, if you copy that formula for black bean taquitos to the jalapeño-apple salsa row, the cell references are automatically adjusted so you calculate the adjusted opening inventory for salsa and not taquitos. In Figure 2-8, the formula in cell E12, which calculates the adjusted ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required