• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Copying Formulas

Sometimes you might want to do the same calculations for different columns or rows. Rather than rebuild the formula from scratch in each place, you can simply copy from one location to another. Excel is smart enough to change the formula automatically to refer to the new column or row.

To copy a formula to adjacent cells:

1.
Click the cell containing the formula (Figure 11.40).

Figure 11.40. Click the cell that contains the formula.


2.
Drag the fill handle at the lower-right corner of the cell across the adjacent cells to which you want to copy the formula (Figure 11.41). The formula results appear in each cell (Figure 11.42).

Figure 11.41. Drag the fill handle across adjacent cells.


Figure 11.42. The formula is copied to the selected cells. Excel adjusts the formula as it copies it across the columns so that the totals reflect the numbers in that column.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint