Copy or Move a Formula in Excel 2010


You should know what happens to a cell reference or references when a formula in it is moved or copied to different cell references. The following tutorial will describe how to copy or move a formula and what changes take place when you copy or move formulas in Excel 2010 Application.


To Copy a formula, do the Following

1) Select the cell that contains a formula that you want to copy and then press CTRL+C (Copy).


Figure 1



2) Then, on the “Home” tab, in the ‘clipboard’ category, click on the ‘Paste’ icon. If you want only the formula to be copied, then select ‘formulas (F)’ option from the drop down list of the ‘Paste’ icon. If you want to copy only the formula result, then under ‘Paste Values’, click on the ‘Values (V)’ option from the drop down list of the ‘Paste’ icon. You can also use CTRL+V to paste the formula.

3) When you copy a formula, the cell references might be change depending upon the type of cell references that the formula uses. For example, if you copy the formula =SUM(A1,A2) that is present in cell A5 to a cell B5, then the formula that you copy will appear as =SUM(B1,B2) in the cell B5 and returns the summation of values present in cells B1 and B2.


Figure 2



To Move a Formula, do the following

1) Select the cell that contains a formula that you want to move and then press CTRL+X (Cut)

2) Then, on the “home” tab, in the ‘clipboard’ category, click on the ‘Paste’ icon.

3) To paste only the formula, click on the ‘Formulas (F)’ option from the drop down list of the ‘Paste’ icon.

4) When you move a formula from one cell to another, the cell references that were present in the original formula will be retained independent of the type of cell references that you might have used in the formula.


Figure 3




So, this is how you can copy or move a formula in the Excel 2010 Application.



Read Other Applications