Copy formula in Ms-excel 2010
Now we are going to learn about the how to copy formula in Ms-excel 2010.
Copy formula in Excel 2010
Whenever we have used copy option of excel formula excel will automatically adjust it. Suppose we want to add three column A1, A2, A3 sum of three column will come on A4.
Example
Now we will copy formula that is select the column A4 now press ctrl+c and select the column B4 and press ctrl +v. Now we will give any value in B1,B2,B3 Excel will automatically add three of column sum out of in B4 .
Example2