Thursday 12 January 2017

CREATING AND COPYING FORMULAS

Creating / copying formulas 

Microsoft Excel provide a really quick way to copy a formula down a column. You just do the following:

  • Enter a formula in the top cell.
  • Select the cell with the formula, and hover the mouse cursor over a small square at the lower right-hand corner of the cell, which is called the Fill handle. As you do this, the cursor will change to a thick black cross.
  • Hold and drag the fill handle down the column over the cells where you want to copy the formula.
 
 
 

0 comments:

Post a Comment