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

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

文章源自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

2. 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

文章源自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

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.

But always the variable value from this column B.

And that’s it.