Copying Formulas
You copy a cell containing a formula the same way you copy any other cell in Excel: with the Copy and Paste commands, with the fill handle, or with the Fill command. These methods are discussed earlier in this chapter.
Generally speaking, Excel does not make an exact copy of a formula. Instead, it copies the formula based on the kinds of references used within it. If relative references are used, Excel changes them based on the location of the destination cell in relation to the source cell. You can see an example of this in Figures 43 and 44.
Figure 43. Here's a formula to calculate markup percentage. If the company has 763 products, would you want to write the same basic formula 762 more times? Of course not!
Figure 44. Copying ...
Get Microsoft Excel X for Mac OS X: Visual QuickStart Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
