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

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.

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.

No credit card required