Copy formula in Ms-excel 2010

Now we are going to learn about the how to copy formula in Ms-excel 2010.
  • 9209

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

excelimage1.jpg

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

excel image2.jpg

Categories

More Articles

© 2020 DotNetHeaven. All rights reserved.