O'Reilly logo

Learn Excel 2011 for Mac by Guy Hart-Davis

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

Entering Formulas Quickly by Copying and Using AutoFill

In many worksheets, you'll need to enter related formulas in several cells. For example, say you have the worksheet shown in Figure 5–4, which lists a range of products with their prices and sales. Column D needs to show the total revenue derived by multiplying the Units figure by the Price value.

images

Figure 5–4. When a worksheet needs similar formulas in a column or row, you can enter one formula manually and then use AutoFill or Copy and Paste to enter it quickly in the other cells.

Each cell in column D needs a different formula: Cell D2 needs =B2*C2, Cell D3 needs =B3*C3, and so on. Because ...

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