Now you have applied the formula to every cell in the column. Select the cell formulas you want to add to and click Kutools More Convert Refers. Type the plus sign into the formula after A3.
B6C2 and press Enter.
Now select cell C6 and the other cells in the column where you want to apply the formula. Click cell B5 point mouse to bottom right of cell B5 until the cursor change shape become thinner. As you update the table it will automatically update the heading as well. In addition to using the keyboard there is another way to copy the formula which is using the mouse.