how to apply a formula with a fixed cell to the whole column in EXCEL

admin ExcelComments436Read

I am going to learn how to apply a formula to the whole column in EXCEL.

In the cell C2, I prepared a formula which basically is the sum of a fixed value from column A and a variable value from column B.文章源自LuckYou.ORG-https://luckyou.org/128.html

how to apply a formula with a fixed cell to the whole column in EXCEL文章源自LuckYou.ORG-https://luckyou.org/128.html

1. SUM the two value文章源自LuckYou.ORG-https://luckyou.org/128.html

We click into the cell C2.文章源自LuckYou.ORG-https://luckyou.org/128.html

Type the equation to sum A2 and B2文章源自LuckYou.ORG-https://luckyou.org/128.html

=A2+B2

how to apply a formula with a fixed cell to the whole column in EXCEL2. Fix the value文章源自LuckYou.ORG-https://luckyou.org/128.html

Because the fixed value is in the cell A2, what we will do now is basically inserting a dollar sign to “fix the A2”文章源自LuckYou.ORG-https://luckyou.org/128.html

=$A$2+B2

how to apply a formula with a fixed cell to the whole column in EXCEL文章源自LuckYou.ORG-https://luckyou.org/128.html

3. copy the equation文章源自LuckYou.ORG-https://luckyou.org/128.html

And now we hit the enter key and again select this cell but now we move our cursor downwards to the bottom right corner of the cell until it changes to this black little cross.文章源自LuckYou.ORG-https://luckyou.org/128.html

how to apply a formula with a fixed cell to the whole column in EXCEL

And when we drag this cross downwards with our mouse, we can see that the formula will be applied to this column.

As you can see in all the cells we now have the formula which contains this fixed value from column A.

how to apply a formula with a fixed cell to the whole column in EXCEL

But always the variable value from this column B.

 

And that’s it.

 
匿名

Comment

Anonymous

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

Decide