• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 11. Formulas and Functions > Copying a Formula to Adjacent Cells

Copying a Formula to Adjacent Cells

You'll sometimes want to perform the same calculation for additional columns or rows. For example, in a worksheet that shows sales by region, you may wish to display a total for every column of sales figures. Rather than rebuild the formula from scratch, you can copy it to adjacent cells. Excel changes the formula automatically to refer to each column or row's data.

To copy a formula to adjacent cells:

1.
Click the cell containing 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.13).

Figure 11.13. From the original cell (B9), click and drag the fill handle across the destination cells (C9–E9). (To perform this copy operation on rows, such as the averages in column F, you would drag down.)


The formula's results appear in the cells and the Auto Fill Options button appears (Figure 11.14).

Figure 11.14. The results appear in the destination cells (C9–E9). Click the Auto Fill Options button to review formatting options.


3.
Optional: To change the format in the destination cells, click the Auto Fill Options button and choose a formatting option from the drop-down menu.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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